Episode 282 – Getting started with Power Query
In Episode 282 of the podcast, Scott and Ben discuss how to use Power Query to automate data ingestion from Azure Data Explorer and Azure DevOps into Excel. Power Query allows you to query data from multiple sources and combines it with relationships and visualizations seamlessly. The podcast provides tips and tricks to get started with Power Query and create compelling data reports that provide insights.
The show notes of the podcast include various resources you can use to learn more about Power Query, such as the REST APIs for Azure DevOps, OData.Feed, and Microsoft Power BI Downloads. The podcast also features the sponsors, Intelligink, who help businesses implement and administer their Microsoft cloud technology solutions.
If you want to master Power Query and unlock the full potential of data reporting and analysis, this podcast is an excellent resource to get started.
Published on:
Learn moreRelated posts
Understanding What Data Modeling Is And Creating The Right Relationships
In this tutorial, you'll learn about the concept of data modeling and how to create the right relationships between different data tables in y...
Power BI Introduction Power BI Desktop | Power BI Service | Power Query | Data Modelling Data Visualization | Power BI Mobile Data Connectivity
Microsoft Power BI is a powerful and popular business intelligence and data visualization tool or suite developed by Microsoft. It enables use...
Excel: Refresh queries from Authenticated Data Sources in Excel for the Web
Excel for the Web has made it possible to refresh Power Query data from authenticated data sources. This means that data sources requiring aut...
Sagar Lad: Data DevOps and Security - Episode 248
Sagar Lad, a Technical Solution Architect, shares his expertise on implementing Data & Analytics solutions for large enterprises through C...
Mastering DP-500: Performance Tuning of Power Query and Data Sources
If you're looking to optimize the performance of your Power BI solutions, this article is a must-read. Performance tuning can be a complex and...
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 Exp...
Where is your Data? - A need for Data governance platform
The advent of digital transformation and app modernization programs has led to the generation, movement, collection, and storage of data in th...
FAST - Billions of rows with Azure Data Explorer (ADX)
In this video, we explore the capabilities of Azure Data Explorer (ADX) in processing vast amounts of data quickly and efficiently. ADX is a p...
Azure Data Factory (ADF) Quick Tip: Invoking REST APIs Using External Call Transform
If you're looking for a quick tip on using Azure Data Factory (ADF) and invoking REST APIs using External Call Transform, this video is just w...