Blog |Delice Consulting Cabinet de conseil IT et Data
16 Aug

Displaying The Output Of Detail Rows Expressions In Power BI Reports Using The Paginated Report Visual

In last week’s post I mentioned that while Power BI reports (unlike Excel PivotTables) do not support the Detail Rows Expression feature, it is possible to partially work around this limitation by using the paginated report visual. In this post I’ll show you how I was able to do this and what is and isn’t … Continue reading Displaying The Output Of Detail Rows Expressions In Power BI Reports Using The Paginated Report Visual →

By Chris Webb DAX, Paginated reports , Power BI comments Read More
09 Aug

Using Detail Rows Expressions To Drill To A Different Fact Table In Power BI

If you have a DirectQuery fact table in Power BI you can use user-defined aggregations to improve query performance; querying a smaller, summarised copy of your data in an Import mode aggregation table is always going to be faster than querying a large fact table containing all your detail data that is in DirectQuery mode. … Continue reading Using Detail Rows Expressions To Drill To A Different Fact Table In Power BI →

By Chris Webb Aggregations, DirectQuery , Import Mode comments Read More
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