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
Power BI Progress Bar You Haven't seen Before
9 hours ago
Diagnosing Power BI DirectQuery Performance Problems Caused By SQL Queries That Return Large Resultsets
One very common cause of Power BI performance problems is having a table with a large number of rows on your report. It’s a problem I wr...
3 days ago
What happened in DAX in 2025
8 days 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 ...
10 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...
17 days ago