Posts filed under Power Query

Incremental Refresh for Power BI Pro!

Video by: Reid Havens

Learn about the latest feature to move from Power BI Premium to Power BI Pro licenses, Incremental Refresh! This allows you to refresh only a portion of the data that has changed, based on date fields.

RELATED LINKS

Incremental Refresh Doc

Query Folding Doc

Posted on March 10, 2020 and filed under Intermediate, Performance/Optimization, 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

Posted on January 28, 2020 and filed under Advanced, DAX, Power Query.

Maintaining Query Folding when Distinct Counting in Power Query

Video by: Reid Havens

Learn how to count distinct rows in Power Query while maintaining Query Folding! No file download with this weeks video.

Power Query Folding Guidance

Posted on January 21, 2020 and filed under Beginner, 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

Posted on January 7, 2020 and filed under Intermediate, Power Query.