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.

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.