Anti Joins And Query Folding In Power Query In Excel And Power BI
Power Query allows you to merge (“join” in database terms) two tables together in a variety of different ways, including left and right anti joins. Unfortunately, as I found recently, anti joins don’t fold on SQL Server-related data sources, which can result in performance problems. Luckily there is a different way of doing anti joins… Continue reading Anti Joins And Query Folding In Power Query In Excel And Power BI
Published on:
Learn moreRelated posts
What happened in DAX in 2025
1 day ago
Diagnosing Power BI DirectQuery Connection Limit Problems With Performance Analyzer
To kick off my series on diagnosing Power BI performance problems with Performance Analyzer in the browser (which I introduced last week with ...
4 days ago
Visualising Power BI Performance Analyzer Data With A Vibe-Coded Custom Visual
Performance Analyzer is now available in the browser, not just in Power BI Desktop! Actually everyone got excited about this back in September...
10 days ago
Why Power BI Reports Become Slow in Production
15 days ago