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

The Power BI DataViz World Championships are coming to FabCon Vienna!

The Power BI DataViz World Champs – EU Edition kicks off today! Explore the dataset, enter the competition, and compete for a spot on stage at...

1 day ago

Standalone Copilot in Power BI will be turned on by default in September

Starting on or after September 1, 2025, the standalone Copilot experience will be enabled by default for all tenants where Copilot has already...

3 days ago

Why Do Power BI Copilot AI Instructions Seem To Work Better in Desktop Than In The Service?

I’m spending a lot of time with organisations testing Power BI Copilot at the moment, and something I hear a lot is that Copilot works w...

3 days ago

Storytelling with Power BI Scatter Chart

Column or Bar chart can be easily used for showing a single measure’s insight across a category. Mixed charts such as Line and Column ch...

5 days ago

Introducing the Fabric Notebooks Competition for Power BI

Join the Power BI Notebooks Competition this August to showcase your creativity and contribute to the community gallery.

6 days ago

Introducing the First-Ever Fabric Notebooks Competition for Power BI!

Join the Power BI Notebooks Competition this August to showcase your creativity and contribute to the community gallery.

6 days ago

Power BI Cognitive Services and Azure Machine Learning features retiring; transition to Fabric AI services

Power BI is retiring Cognitive Services and Azure Machine Learning features by September 15, 2025, transitioning AI capabilities to Microsoft ...

7 days ago

Running a Power BI Performance load test using Visual Studio Code

This is the final part of my blog series for Power BI Performance testing, where I will finally run the Power BI Performance Load testing usin...

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