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
Optimising DAX: The Formula Engine and Storage Engine
When you execute a DAX query, two engines divide up the work. Understanding the split between the formula engine and the storage engine is key...
1 day ago
How Microsoft Fabric, Azure, and Power BI Are Transforming Analytics
Introduction Data has become one of the most valuable assets for modern organisations. However, collecting data alone is no longer enough—busi...
4 days ago
Agentic AI in Power BI and Fabric, Part 4: From Skills to an Agentic Report Theme Audit Workflow
In Part 1, I went through the concepts and terminology behind agentic AI, things like agents, tools, skills, MCP, guardrails, and Human i...
4 days ago
Analysing Power BI Data Using Copilot In Excel
This week there was another big Copilot-related announcement for Power BI – but on the Excel blog. You can now analyse data from Power B...
4 days ago
Simplify Power BI DAX with Visual Calculations
10 days ago
Excel or Power BI: Why Start Over?
10 days ago
Power BI, M365 Copilot And The Importance Of DAX UDFs
This was a big week for Power BI Copilot with the announcement of a new direction for the feature. If you haven’t done so already, read ...
11 days ago
Power BI Update - July 2026
15 days ago