Loading...

Anti Joins And Query Folding In Power Query In Excel And Power BI

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 more
Chris Webb's BI Blog Chris Webb's BI Blog
Chris Webb's BI Blog Chris Webb's BI Blog

A blog about Power BI, SQL Server Analysis Services (Multidimensional and Tabular), MDX, DAX, Power Pivot, Power Query, M, Power Map and Excel for BI

Share post:

Related posts

TMDL View And Power BI Developer Productivity: An Example Using The Detail Rows Definition Property

For me the biggest new feature in the January 2025 release of Power BI Desktop is the new TMDL View; many other people like Marco are excited ...

3 hours ago

Deep dive into TMDL view for Power BI Desktop (Preview)

We’re excited to introduce TMDL view for Power BI Desktop. This new feature lets you script, modify, and apply changes using Tabular Model Def...

3 days ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy