Blog |Delice Consulting Cabinet de conseil IT et Data
19 Jul

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 that actively monitors and analyses Pipeline activity. And that got me thinking, since Workspace Monitoring also contains Power BI activity data, why not create an Operations Agent to actively monitor Power BI too? … Continue reading Using Fabric Operations Agents And Workspace Monitoring With Power BI →

By Chris Webb Fabric, Operations Agent , Power BI comments Read More
05 Jul

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 the physical machine, or node, that a semantic model is running on in the Power BI Service comes under memory pressure. Recently, someone I was working with who was doing some load testing … Continue reading Understanding The “Database Was Evicted To Balance The CPU Load” Error In Power BI →

By Chris Webb Power BI, , comments Read More
28 Jun

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 has been the same: use Import mode unless you have a really, really good reason to use DirectQuery mode and even then you’re probably wrong and should use Import mode. … Continue reading Power BI DirectQuery Mode: A Better Choice Than You Might Think →

By Chris Webb Direct Lake, DirectQuery , Fabric comments Read More
21 Jun

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-related books (and there are fewer and fewer of them being published) that I receive free copies of, here’s the second edition of a book that for some reason I missed first time around: “Extreme DAX”. … Continue reading New Book: “Extreme DAX” 2nd Edition →

By Chris Webb Books, DAX , Power BI comments Read More
14 Jun

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. I will take a look at them all in my next few posts; in this first post I’ll look at the ability to disable V-Order on staged data. As the (very detailed) documentation for this … Continue reading Improve Performance Of Staging In Fabric Dataflows Gen2 By Disabling V-Order →

By Chris Webb Dataflows, Fabric , Performance Tuning comments Read More
07 Jun

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 tests to see how much parallelism I could get. To do this I uploaded 244 identical Excel files containing almost 542000 rows of data each to a SharePoint … Continue reading Fabric Dataflows Gen2 And Concurrent Evaluation, Part 3: Is More Parallelism Always Good? →

By Chris Webb Dataflows, Fabric , Performance Tuning comments Read More
31 May

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 multiple queries inside the dataflow. In this post I will show how, with Partitioned Compute, this setting can also affect the performance of a single query within a dataflow. To … Continue reading Fabric Dataflows Gen2 And Concurrent Evaluation, Part 2: Partitioned Compute →

By Chris Webb Dataflows, Performance Tuning , comments Read More
24 May

Fabric Dataflows Gen2 And Concurrent Evaluation, Part 1

Did you know that if your Fabric Dataflows Gen2 contains several queries then you can control how many of them are evaluated in parallel when your dataflow refreshes? In this series I’ll look at how how you can do this and how it may result in better performance – at least in some cases. Let’s … Continue reading Fabric Dataflows Gen2 And Concurrent Evaluation, Part 1 →

By Chris Webb Dataflows, Performance Tuning , comments Read More
17 May

Understanding The “You’ve Exceeded The Capacity Limit For Dataset Refreshes” Error in Power BI

If you have a lot of Power BI semantic models that are scheduled to refresh at the same time in the Service then you may find that some of them fail with the following error: You’ve exceeded the capacity limit for dataset refreshes. Try again when fewer datasets are being processed. [Note: “dataset” is the … Continue reading Understanding The “You’ve Exceeded The Capacity Limit For Dataset Refreshes” Error in Power BI →

By Chris Webb Power BI, Refresh , comments Read More