In Episode 282, Scott talks to Ben about a situation he ran into at work where he wanted to automate the ingestion of data from Azure Data Explorer and Azure DevOps into Excel. They talk about how you can query data from multiple data sources using Power Query and bring that data together with relationships and visualizations.

Like what you hear and want to support the show? Check out our membership options.
Show Notes

Maxforce Quantum 0.03% Imidacloprid Ant Control Liquid Bait with 10 stations, 120 Gram Bottle
Compare Outlook for PC, Outlook on the web, and Outlook for iOS & Android
Share an Outlook calendar with other people
What is Power Query?
Getting data overview
Get started with the REST APIs for Azure DevOps
About Power BI integration
Get webpage data by providing examples
OData.Feed
Microsoft Power BI Downloads

About the sponsors

Intelligink utilizes their skill and passion for the Microsoft cloud to empower their customers with the freedom to focus on their core business. They partner with them to implement and administer their cloud technology deployments and solutions. Visit Intelligink.com for more info.