Blog |Delice Consulting Cabinet de conseil IT et Data
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
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