Not All Query Folding is Created Equal...Performance Tuning PQ

Everyone knows rule number one for Power Query performance is to ensure your query folds as much as possible. What do you do after rule number one? There is more to performance than just folding, and there are multiple approaches that can fold.

In this video, we deep dive into multiple queries with folding that all have different performance characteristics. We'll examine dates and lists and how M generates SQL when folding.

Tune in to see how you can check the efficiency of different folded queries!

GUEST BIO 👤
He slices! He dices! When it comes to Power BI, Greg Baldini does it all, and he is here to show you how to, too!

Co-founder of Argus PBI, Greg has a decade of experience with DAX, Tabular, and the Power BI family of tools. His career has been spent in solving hard problems for clients and seeking deep understanding of the fundamentals of data analysis.

RELATED CONTENT 🔗
Tabular Editor -- https://tabulareditor.com
Argus PBI -- https://www.arguspbi.com
Greg's Website -- https://www.antifound.com

BECOME A CHANNEL MEMBER 🎉
--    / @havensconsulting  

CHECK OUT OUR MERCH STORE 👕
-- https://havens-consulting.creator-spr...

LET'S CONNECT! 🧑🏽‍🤝‍🧑🏽 🌟
--   / havensbi  
--   / reidhavens  
--    / havensconsulting  
--   / havensconsulting  

HAVENS CONSULTING PAGES 📄
Home Page - http://www.havensconsulting.net
Blog -- http://www.havensconsulting.net/blog-...
Blog Files -- http://www.havensconsulting.net/blog-...
Files & Templates -- http://www.havensconsulting.net/files...
Consulting Services -- http://www.havensconsulting.net/consu...
Online Courses -- https://www.havensconsulting.net/onli...
Contact & Support - http://www.havensconsulting.net/conta...

EMAIL US AT 📧
[email protected]

#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodel