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 moreRelated posts
Why should I complete Power BI Performance Load Testing & initial setup
It is becoming increasingly important to understand how the Power BI reports/Semantic Model that are being used in your organization are perfo...
3 days ago
Power BI Copilot, AI Instructions And Preventing The Use Of Implicit Measures
In yet another entry in my series on what you should be doing in Power BI Copilot AI Instructions, in this post I want to address the most dif...
5 days ago
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...
7 days 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.
10 days ago