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 2025 holiday recap: A decade of innovation and impact
2025 was a monumental year for Microsoft Power BI, marked by its 10-year anniversary and a series of community celebrations, global contests, ...
1 day ago
Power BI Copilot And Report Filters And Slicers
In my last post I talked about how to push Power BI Copilot to get answers from the semantic model rather than the report you’re looking...
3 days ago
Help me learn Power BI!
5 days ago
Introducing DAX Lib
5 days ago
Introducing DAX Optimizer Basic
8 days ago