Blog |Delice Consulting Cabinet de conseil IT et Data
02 Nov

Monitoring The DAX Queries Generated When The Power BI Copilot Index Is Built

In my last post I talked about the text index that Power BI Copilot builds to help it answer data questions. You might be wondering if you can monitor the index build process and the bad news is that – at least at the time of writing – you can’t do so directly. However you … Continue reading Monitoring The DAX Queries Generated When The Power BI Copilot Index Is Built →

By Chris Webb Copilot, DAX , Power BI comments Read More
26 Oct

Understanding The “Copilot Analyzed Only Part Of The Model Due To Its Size” Warning In Power BI Copilot

If you’re using Power BI Copilot you may have seen the following warning message: What does it mean? What causes it? What can you do to avoid it? Let’s find out. In order to answer your questions better Power BI Copilot creates an index of the values in all the text columns in your semantic … Continue reading Understanding The “Copilot Analyzed Only Part Of The Model Due To Its Size” Warning In Power BI Copilot →

By Chris Webb Copilot, Power BI , comments Read More
19 Oct

Monitor Fabric Costs With Fabric Cost Analysis

Following on from my blog post a few months ago about cool stuff in the Fabric Toolbox, there is now another really useful solution available there that anyone with Fabric capacities should check out: Fabric Cost Analysis (or FCA). If you have Fabric capacities it’s important to be able to monitor your Azure costs relating … Continue reading Monitor Fabric Costs With Fabric Cost Analysis →

By Chris Webb Fabric, Power BI , comments Read More
12 Oct

First Look At Fabric Graph: Analysing Power BI Import Mode Refresh Job Graphs

The new Fabric Graph database is now rolling out and should be available to everyone within the next few weeks if you can’t see it already. The key to learning a new data-related technology is, I think, to have some sample data that you’re interested in analysing. But if you’re a Power BI person why … Continue reading First Look At Fabric Graph: Analysing Power BI Import Mode Refresh Job Graphs →

By Chris Webb Fabric, Graph , Power BI comments Read More
05 Oct

Snowflake Query Tags In Power BI And Workspace Monitoring

Since I wrote about the Snowflake query tags generated by Power BI earlier this year, one important piece of functionality has been added: an OperationID that allows you to link a SQL query in Snowflake to events in Workspace Monitoring and the Capacity Metrics app. Let’s see some examples. I created a DirectQuery semantic model … Continue reading Snowflake Query Tags In Power BI And Workspace Monitoring →

By Chris Webb Capacity Metrics App, DirectQuery , Import Mode comments Read More
28 Sep

Linking Fabric Warehouse SQL Queries And Spark Jobs To The Capacity Metrics App

Following on from my post two weeks ago about how to get the details of Power BI operations seen in the Capacity Metrics App using the OperationId column on the Timepoint Detail page, I thought it was important to point out that you can do the same thing with TSQL queries against a Fabric Warehouse/SQL … Continue reading Linking Fabric Warehouse SQL Queries And Spark Jobs To The Capacity Metrics App →

By Chris Webb Capacity Metrics App, Fabric , Fabric Spark comments Read More
21 Sep

Finding Power BI Queries And Refreshes That Have Been Throttled With Workspace Monitoring

A lot of new documentation was published recently around Fabric capacities, including documentation on how to size and govern capacities and how to troubleshoot problems with capacities. The latter has instructions on how to use the Capacity Metrics App to determine if your Power BI queries are being throttled; it mentions that you can also … Continue reading Finding Power BI Queries And Refreshes That Have Been Throttled With Workspace Monitoring →

By Chris Webb Capacities, Power BI , Workspace Monitoring comments Read More
14 Sep

How To Get The Details Of Power BI Operations Seen In The Capacity Metrics App

It’s the week of Fabcon Europe and you’re about to be overwhelmed with new Fabric feature announcements. However there is a new blink-and-you’ll-miss-it feature that appeared in the latest version of the Fabric Capacity Metrics App (released on 11th September 2025, version 47) that won’t get any fanfare but which I think is incredibly useful … Continue reading How To Get The Details Of Power BI Operations Seen In The Capacity Metrics App →

By Chris Webb Capacities, Capacity Metrics App , Fabric comments Read More
07 Sep

What Happens When Power BI Direct Lake Semantic Models Hit Guardrails?

Direct Lake mode in Power BI allows you to build semantic models on very large volumes of data, but because it is still an in-memory database engine there are limits on how much data it can work with. As a result it has rules – called guardrails – that it uses to check whether you … Continue reading What Happens When Power BI Direct Lake Semantic Models Hit Guardrails? →

By Chris Webb Direct Lake, Fabric , Power BI comments Read More
31 Aug

Performance Testing Power BI Direct Lake Models Revisited: Ensuring Worst-Case Performance

Two years ago I wrote a detailed post on how to do performance testing for Direct Lake semantic models. In that post I talked about how important it is to run worst-case scenario tests to see how your model performs when there is no model data present in memory, and how it was possible to … Continue reading Performance Testing Power BI Direct Lake Models Revisited: Ensuring Worst-Case Performance →

By Chris Webb Direct Lake, Fabric , Performance Tuning comments Read More