Episode 282 – Getting started with Power Query
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.
Published on:
Learn moreRelated posts
DARK THEME Report in Power BI
9 hours ago
Sync two slicers without bi-directional relationships in Power BI
Have you ever wanted to sync two slicers on a report page? Even when both slicers are coming from different dimensions? A lot of users end up ...
1 day ago
Another Way To Get The SQL Generated By Power BI DirectQuery Mode
If you’re performance tuning a DirectQuery mode semantic model in Power BI, one of the first things you’ll want to do is look at t...
3 days ago
Copilot in Power BI: Your AI-Powered Data Analyst
AI (Artificial Intelligence) has been dominating its impact everywhere and Microsoft Copilot in Power BI is the result of this – becoming a ga...
6 days ago
Industry Use Cases: Power BI and Dynamics 365 Business Central integration
Introduction Microsoft Dynamics 365 Business Central and Power BI together can completely alter how modern businesses operate. Therefore, in t...
6 days ago