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 Update - July 2026
20 hours ago
Microsoft Copilot (Microsoft 365): Power BI integration in M365 Copilot
This release enables M365 Copilot to reason over Power BI enterprise data and returns grounded answers directly from Power BI reports and sema...
2 days ago
Using Fabric Operations Agents And Workspace Monitoring With Power BI
This week, in the announcement about support for Fabric Pipelines in Workspace Monitoring, I noticed that it came with an Operations Agent tha...
3 days ago
Power BI on a Mac: I Love It
6 days ago
I Put 11 Power BI Secrets to The EXPERT Test
6 days ago
Microsoft Viva: Create and customize Power BI reports
Microsoft Viva Insights will allow eligible users to create, customize, and save supported Power BI reports, including adjusting periods, filt...
9 days ago
The Benefits Of Using Direct Lake Mode In Power BI
This is a blog post I’ve been meaning to write for a long time. Since Fabric launched there has been a lot of focus on Direct Lake mode ...
10 days ago