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

Power BI Copilot Summaries honor AI Instructions to provide non-English language responses

In working with Power BI Copilot one of the feedback requests I hear from my customers is being able to support non-English languages. While p...

1 day ago

Updates to Copilot in Power BI: More ways to see, learn from, and ask about your report data

This blog draft gives an overview of updates to access and learn from report data via Copilot.

4 days ago

Data Validation In Power BI Copilot AI Instructions

Here’s yet another post in my series on things I think you should be doing in Power BI Copilot AI Instructions. Today: validating values...

6 days ago

Building Translytical Flows in Power BI Reports

Microsoft has introduced Translytical Task Flows (Preview) in Power BI — a groundbreaking capability that brings transactional actions directl...

8 days ago

What Fields to Hide in Your Power BI Solution?

To tidy up your Power BI solution, there are some options, and one of them is hiding fields from the report view. This option, although simple...

10 days ago

Celebrate with us as Power BI Turns 10!

Power BI is turning 10, and we’re celebrating a decade of turning data into insight and impact. From 500,000 early adopters to over 375,000 or...

12 days ago

Power BI Copilot AI Instructions: Helping Users Understand The Scope Of The Data

Continuing my series of posts on Power BI Copilot and the type of things you should be including in AI Instructions, today I want to talk abou...

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