Blog |Delice Consulting Cabinet de conseil IT et Data
04 Jan

Diagnosing Power BI DirectQuery Performance Problems Caused By SQL Queries That Return Large Resultsets

One very common cause of Power BI performance problems is having a table with a large number of rows on your report. It’s a problem I wrote about here, and while I used an Import mode for my example in that post I also mentioned that this can be an even bigger problem in DirectQuery … Continue reading Diagnosing Power BI DirectQuery Performance Problems Caused By SQL Queries That Return Large Resultsets →

By Chris Webb Custom Visuals, DirectQuery , Performance Analyzer comments Read More
31 Dec

21st Blog Birthday: Centralised And Decentralised BI And AI

As the saying goes, history doesn’t repeat itself but it rhymes. While 2025 has seen the excitement around new advances in AI continue to grow in data and analytics as much as anywhere else, it’s also seen the re-emergence of old debates. In particular, one question has raised its head yet again: should there be … Continue reading 21st Blog Birthday: Centralised And Decentralised BI And AI →

By Chris Webb AI, , comments Read More
28 Dec

Diagnosing Power BI DirectQuery Connection Limit Problems With Performance Analyzer

To kick off my series on diagnosing Power BI performance problems with Performance Analyzer in the browser (which I introduced last week with my post on vide-coding a custom visual to visualise Performance Analyzer data), I want to revisit a subject I blogged about two years ago: how hitting the limit on the maximum number … Continue reading Diagnosing Power BI DirectQuery Connection Limit Problems With Performance Analyzer →

By Chris Webb DirectQuery, Performance Analyzer , Performance Tuning comments Read More
21 Dec

Visualising Power BI Performance Analyzer Data With A Vibe-Coded Custom Visual

Performance Analyzer is now available in the browser, not just in Power BI Desktop! Actually everyone got excited about this back in September when it was announced and then forgot about it because it didn’t appear immediately, but now if you are in Edit mode for a published report you can see Performance Analyzer is … Continue reading Visualising Power BI Performance Analyzer Data With A Vibe-Coded Custom Visual →

By Chris Webb Custom Visuals, Performance Analyzer , Power BI comments Read More
07 Dec

Stopping Power BI Copilot From Answering Questions From Report Visuals

When you ask Power BI Copilot a data question, the first thing it will do is try to answer that question using information from report visuals; if it can’t find the answer on a report page it will then go on try to build a new visual or generate a DAX query. Most of the … Continue reading Stopping Power BI Copilot From Answering Questions From Report Visuals →

By Chris Webb AI Instructions, Copilot , Power BI comments Read More
30 Nov

A Look At The Impact Of Calendar Based Time Intelligence On Power BI DirectQuery Performance

Calendar-based time intelligence (see here for the announcement and here for Marco and Alberto’s more in-depth article) is at least the second-most exciting thing to happen in DAX in the last few months: it makes many types of time intelligence calculation much easier to implement. But as far as I know only Reid Havens, in … Continue reading A Look At The Impact Of Calendar Based Time Intelligence On Power BI DirectQuery Performance →

By Chris Webb DAX, DAX Studio , DirectQuery comments Read More
16 Nov

Linking Queries Run From DAX Studio To Workspace Monitoring And The Capacity Metrics App

A few weeks ago I wrote a blog post about how you can now link event data from Workspace Monitoring to data in the Fabric Capacity Metrics App using OperationId values. In the latest (3.4.0) release of DAX Studio there’s a new feature that you might have missed that link queries run from there to … Continue reading Linking Queries Run From DAX Studio To Workspace Monitoring And The Capacity Metrics App →

By Chris Webb Capacity Metrics App, DAX , DAX Studio comments Read More