Blog |Delice Consulting Cabinet de conseil IT et Data
15 Jun

Grouping And Filtering In Power BI Copilot AI Instructions

Continuing my series on Power BI Copilot AI Instructions (see also my previous post which is the only other one so far), in this post I’d like to show some examples of how you can specify groups of columns and apply row filters in the results returned by Copilot. Using the same semantic model that … Continue reading Grouping And Filtering In Power BI Copilot AI Instructions →

By Chris Webb AI Instructions, Copilot , Fabric comments Read More
08 Jun

Requiring Selections On The Date Dimension In Power BI Copilot AI Instructions

Without a doubt the most important new feature in Power BI Copilot is AI Instructions: it opens up an immense number of possibilities but it also starts off as a blank slate, which raises the question of what you should do with this feature as much as how you should do it. The official documentation … Continue reading Requiring Selections On The Date Dimension In Power BI Copilot AI Instructions →

By Chris Webb AI Instructions, Copilot , Power BI comments Read More
01 Jun

Finding Reports And Semantic Models Easily With Power BI Copilot Search

By the time you read this it’s likely the new, standalone Power BI “Chat with your data” experience will be available in your tenant. I just enabled it in the tenant the Fabric CAT team uses for testing purposes, located in the West Europe region, after the option to do so appeared yesterday. If you’re … Continue reading Finding Reports And Semantic Models Easily With Power BI Copilot Search →

By Chris Webb Copilot, Fabric , Power BI comments Read More
25 May

Generating Sample Data With Copilot In Fabric Dataflows Gen2

As a Power Query fan I’m naturally interested in Copilot in Dataflows Gen2. But since Power Query is already very easy to use and since I’m pretty experienced at using it, can Copilot really do anything to help me be more productive? Well one thing I need to do a lot for blog posts, demos … Continue reading Generating Sample Data With Copilot In Fabric Dataflows Gen2 →

By Chris Webb Copilot, Dataflows , Fabric comments Read More
18 May

Performance Implications Of Different Ways Of Fully Expanding A Power BI Matrix Visual

If you have a Power BI report with a matrix visual on it it’s quite likely that you’ll want all the levels in the matrix to be fully expanded by default. But did you know that the way you expand all the levels could have performance implications, especially if you’re using DirectQuery mode? Here’s an … Continue reading Performance Implications Of Different Ways Of Fully Expanding A Power BI Matrix Visual →

By Chris Webb DirectQuery, Performance Tuning , Power BI comments Read More
11 May

Finding Events Linked To A Specific Power BI Visual In Fabric Workspace Monitoring

Over the last few years one topic I have blogged about several times is how to link the detailed data about DAX query execution that can be found in Log Analytics – and now Workspace Monitoring – to the visual in a Power BI report that generated those DAX queries, something that is extremely useful … Continue reading Finding Events Linked To A Specific Power BI Visual In Fabric Workspace Monitoring →

By Chris Webb Fabric, Power BI , Workspace Monitoring comments Read More
04 May

Documenting Power BI Semantic Models With Fabric Data Agents

AI is meant to help us automate boring tasks, and what could be more boring than creating documentation for your Power BI semantic models? It’s such a tedious task that most people don’t bother; there’s also an ecosystem of third party tools that do this job for you, and you can also build your own … Continue reading Documenting Power BI Semantic Models With Fabric Data Agents →

By Chris Webb Data Agents, Fabric , Power BI comments Read More
20 Apr

Memory Overhead Of Distinct Count Measures In Power BI

The series of blog posts I wrote last year on semantic model memory usage, in particular this post on the query memory limit and the “This query uses more memory than the configured limit” error in Power BI, gets a lot of traffic. Since writing that post on the query memory limit I’ve written a … Continue reading Memory Overhead Of Distinct Count Measures In Power BI →

By Chris Webb DAX, Performance Tuning , Power BI comments Read More