Havens Consulting
Video by: Reid Havens
Learn how to maintain your query folding when needing to merge (join) queries in Power Query, but when the merge keys are different data types, and when converting data types might initially break your query folding. Tune in to learn more!
Video by: Reid Havens
Learn how to write simpler M-Code which maintains Query Folding. Features like Column from Example can be very powerful in helping you create new columns in Power Query, but the code it writes might not always fold! You can fix this with a bit of light M code edits, and maintain your Query Folding. Tune in to learn more!
Video by: Reid Havens
Learn about five useful tips and techniques for upgrading your Power Query skills. These tips can be useful for those just getting started in Power Query, and even for those maybe a bit more familiar or intermediate with the tool. Tune in to learn more!
Referencing Other Queries
Data Profiling Tools
Using Parameters
Sharing Queries
Query Folding
Video by: Reid Havens
Learn how to count distinct rows in Power Query while maintaining Query Folding! No file download with this weeks video.
Signup for our mailing list to gain access to Power BI files and templates from the videos. You’ll receive a welcome email with a link and password to the Blog Files page.
Reid Havens’ early love affair with analytics has, over the past decade, turned into an evolution into data visualization and report design in Power BI.
Since then Reid has been writing articles and creating YouTube videos to share the word of BI, helping to inspire the next generation of Business Intelligence enthusiasts.
