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
Microsoft Power BI & Fabric Licensing | Part 01
4 hours ago
Convert rows to columns using Power Query – Excel and Power BI
If you get data in a single column with multiple records, you can easily convert it to multiple columns using Power Query. Watch and Try with ...
1 day ago
SWITCH between TIME SLICERS in Power BI
2 days ago
Creating [DAX] SVG Charts using Chat GPT!
4 days ago