Sun.Apr 14, 2024

article thumbnail

New Semi Join, Anti Join And Query Folding Functionality In Power Query

Chris Webb BI

There are a couple of nice new features to do with table joins (or merges as they are known in M) and query folding in Power Query in the April release of Power BI Desktop that I want to highlight. Anti Joins now fold First of all, a few months ago I wrote a post about how the built-in anti join functionality didn’t fold in Power Query. The good news is that it now does on SQL Server-related sources, so no more workarounds are needed.