New Semi Join, Anti Join And Query Folding Functionality In Power Query
Published on:
Learn moreRelated posts
Analysing Power BI Data Using Copilot In Excel
This week there was another big Copilot-related announcement for Power BI – but on the Excel blog. You can now analyse data from Power B...
Power BI, M365 Copilot And The Importance Of DAX UDFs
This was a big week for Power BI Copilot with the announcement of a new direction for the feature. If you haven’t done so already, read ...
Using Fabric Operations Agents And Workspace Monitoring With Power BI
This week, in the announcement about support for Fabric Pipelines in Workspace Monitoring, I noticed that it came with an Operations Agent tha...
The Benefits Of Using Direct Lake Mode In Power BI
This is a blog post I’ve been meaning to write for a long time. Since Fabric launched there has been a lot of focus on Direct Lake mode ...
Understanding The “Database Was Evicted To Balance The CPU Load” Error In Power BI
A few months ago I wrote about a rare error – the “Maximum allowable memory allocation” error – that may occur when th...
Power BI DirectQuery Mode: A Better Choice Than You Might Think
For as long as I’ve been using Power BI – which has been from the beginning – the advice about which storage mode to choose ...
New Book: “Extreme DAX” 2nd Edition
“Extreme DAX” by Michiel Rozema, Madzy Stikkelorum and Henk Vlootman Continuing my series of not-reviews of the latest Power BI-re...
Improve Performance Of Staging In Fabric Dataflows Gen2 By Disabling V-Order
Quite a few new Dataflows Gen2 features were released recently without much fanfare, but that doesn’t mean they aren’t important. ...
Fabric Dataflows Gen2 And Concurrent Evaluation, Part 3: Is More Parallelism Always Good?
To finish off my series of posts on concurrent evaluation in Fabric Dataflows Gen2 (see part 1 and part 2) I decided to do some more realistic...
Fabric Dataflows Gen2 And Concurrent Evaluation, Part 2: Partitioned Compute
In the first part of this series I showed how the Concurrency setting in a Fabric Dataflows Gen2 can affect refresh performance when there are...