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

How to Set Up Agentic Semantic Model Development for Power BI Using GitHub Copilot on Windows

I was inspired and in awe after watching the video that Rui Romano posted in LinkedIn where Rui shared a video on how he used Agentic model de...

1 day ago

Agentic AI in Power BI and Fabric, Part 2: Getting Started with VS Code, GitHub Copilot, and Safe MCP Setup

A Personal Note Before We Continue Before I continue this series, I want to briefly share why it took me so long to publish this second blog. ...

2 days ago

Power BI And Support For Third Party Semantic Models

I’ve been working with Microsoft BI tools for 28 years now and for all that time Microsoft has been consistent in its belief that semantic mod...

3 days ago

Microsoft Viva: Unlocking Deeper Copilot Insights with Enhanced Power BI Filtering

Enable Global and Insights admins to turn on additional attributes as filters in Power BI reports, including reserved attributes and your orga...

3 days ago

What now for Power BI? The question I can’t escape

Everyone keeps asking me the same question: what now for Power BI? With Microsoft Fabric reshaping its identity and AI-generated dashboards ch...

14 days ago

Setting up Power BI Version Control with Azure Dev Ops

In this blog post is a way set up version control for Power BI semantic models (and reports) using the PBIP (Power BI Project) format, Azure D...

15 days ago

Chat with Copilot inside a report on the Power BI mobile app (Preview)

If you haven’t already, check out Arun Ulag’s hero blog “FabCon and SQLCon 2026: Unifying databases and Fabric on a single, complete platform”...

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