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

Understanding Power BI Totals: The Math, the Model, and the Misconceptions

The long-running debate around how Power BI calculates totals in tables and matrices has been part of the community conversation for years. Gr...

7 hours ago

Prep Your Data for AI — Now in the Power BI Service 

Until now, preparing your data for AI was only possible in Power BI Desktop. That changes today! As of today, we are rolling out the ability f...

2 days ago

Deprecation of Metric Sets in Power BI

The Metric Sets feature in Power BI will be deprecated, with a phased retirement beginning October 25th, 2025. What’s Changing and When Scorec...

3 days ago

Business Central 2025 wave 2 (BC27): Access open-sourced Power BI apps

Hi, Readers.Dynamics 365 Business Central 2025 wave 2 (BC27) is generally available. More details: General Available: Dynamics 365 Busine...

4 days ago

Snowflake Query Tags In Power BI And Workspace Monitoring

Since I wrote about the Snowflake query tags generated by Power BI earlier this year, one important piece of functionality has been added: an ...

4 days ago

How to quickly find rows with errors in Power Query when using Power BI

In the past when there has been an error when loading data into the semantic model, there can be times when clicking on the View errors can ei...

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