Posts filed under Power Query

Template for Extracting Report Level Measures from Live Connection PBIX Files

Video by: Reid Havens

Learn about a report I built that will connect to any local (PBIX) file that is using a live connection, and extract any report-level measures from that file. Live connections include (PBIX) files connected to: SQL Server Analysis Services (SSAS) models, Azure Analysis Services (AAS) models, and Power BI Shared Datasets.

Stephanie Bruno - Power BI Field Finder

Tweet from Marco Russo about unzipping PBIX files

Visit the Files Store
Posted on January 28, 2020 and filed under Advanced, DAX, Power Query.

Return Custom Error Message for Any Issue in Power Query

Video by: Reid Havens

Learn how to return custom error messages whenever any applied step in a Power Query query fails. More info about the m code function used to achieve this can be found below.

https://docs.microsoft.com/en-us/powerquery-m/error-record

Download Report From The Blog Files Page
Posted on January 7, 2020 and filed under Intermediate, Power Query.