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
Understanding how DAX evaluates IF statements
3 hours ago
Grouping And Filtering In Power BI Copilot AI Instructions
Continuing my series on Power BI Copilot AI Instructions (see also my previous post which is the only other one so far), in this post I’...
1 day ago
Important Update: Token Protection Policy for Power Query in Excel
Important Update: Token Protection Policy for Power Query in Excel may block data import scenarios requiring Azure Active Directory authentica...
4 days ago
Fabric Fridays: Power BI Copilot
4 days ago
Open and edit any semantic model with Power BI tools
This month, we’re excited to share a major milestone for Power BI modelling tools – Power BI Desktop is now compatible with any semantic model...
5 days ago
Set Up a Dynamic Forecast Band in Power BI
5 days ago
Power BI Model Analysis using DAX INFO Functions
There are many DAX functions for covering day-to-day business-related calculations using measures and calculated columns. However, there is al...
5 days ago