Blog |Delice Consulting Cabinet de conseil IT et Data

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?

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

Useful Community Tools And Resources For Power BI And Fabric

There are a lot of really cool free, community-developed tools and resources out there for Power BI and Fabric – so many that it’s easy to miss announcements about them. In this post I thought I’d highlight a few that came out recently and which you might want to check out. Let’s start with the … Continue reading Useful Community Tools And Resources For Power BI And Fabric

Power BI Copilot, AI Instructions And DAX Measure Definitions

Continuing my (already very long) series on what information you should be adding to the AI Instructions of your semantic model and why, in this post I’ll show you the benefits of adding the DAX definitions of your measures. A really common question from end users viewing a Power BI report is “how is this … Continue reading Power BI Copilot, AI Instructions And DAX Measure Definitions

Why Do Power BI Copilot AI Instructions Seem To Work Better in Desktop Than In The Service?

I’m spending a lot of time with organisations testing Power BI Copilot at the moment, and something I hear a lot is that Copilot works well in Desktop but when you publish your model to the Power BI Service the results are a lot more inconsistent. One reason why is because of how updates to … Continue reading Why Do Power BI Copilot AI Instructions Seem To Work Better in Desktop Than In The Service?

Power BI Copilot, AI Instructions And Visualisation Guidelines

If there are specific ways you want your data to be visualised by Power BI Copilot then you have two options. You can use Verified Answers to link questions to visuals on your reports and can even set them up so users can apply filters to these visuals in their prompts. Alternatively – and this … Continue reading Power BI Copilot, AI Instructions And Visualisation Guidelines

Power BI Copilot, AI Instructions And Semantic Model Relationships

Power BI Copilot knows about the relationship between measures and tables, which means that it’s very good at knowing which measures can be broken down by which columns. For example, consider the following model with two fact tables, one of which contains sales data dimensioned by Employee and Customer, and one which contains target data … Continue reading Power BI Copilot, AI Instructions And Semantic Model Relationships

Power BI Copilot, AI Instructions And Dealing With Ambiguity

One of the most common questions I hear about Power BI Copilot is how you can stop it from guessing what a user means when they ask an ambiguous question, and instead get it to ask for clarification. This is an interesting problem because Copilot already does this and what you really want is a … Continue reading Power BI Copilot, AI Instructions And Dealing With Ambiguity

Power BI Copilot, AI Instructions And Preventing The Use Of Implicit Measures

In yet another entry in my series on what you should be doing in Power BI Copilot AI Instructions, in this post I want to address the most difficult (in terms of deciding what to do, rather than how to do it) topic: whether you should allow the creation of implicit measures. A quick recap … Continue reading Power BI Copilot, AI Instructions And Preventing The Use Of Implicit Measures