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

Connecting Power BI Semantic Models To Data Sources Automatically With Binding Hints

Did you know that you can configure your Power BI semantic model so that it automatically binds to a data source connection when you publish? ...

3 days ago

Power Pages – Support for Power BI Embed Token v2 for Power Pages

We are announcing the ability to utilize Power BI Embed Token v2 for Power Pages. This feature will reach general availability on May 30, 2026...

6 days ago

Predicting the Future: Using Power BI to Identify Your Most Profitable Agencies

In the 2026 federal landscape, "growth" is no longer a broad target—it’s a surgical strike. If your executive team is still making "bid/no-bid...

13 days ago

Custom FetchXML Aggregation in Power Pages — Build a KPI Dashboard Without Power BI

Overview Power BI is a great tool — but it requires additional licensing, an embed configuration, and adds complexity to your portal architect...

13 days ago

Power BI Integration with GITHUB

While Azure DevOps is usually the easiest choice for Microsoft users, connecting Power BI to GitHub is becoming a must-have skill for anyone u...

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