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

Fabric Dataflows Gen2 And Concurrent Evaluation, Part 3: Is More Parallelism Always Good?

To finish off my series of posts on concurrent evaluation in Fabric Dataflows Gen2 (see part 1 and part 2) I decided to do some more realistic tests to see how much parallelism I could get. To do this I uploaded 244 identical Excel files containing almost 542000 rows of data each to a SharePoint … Continue reading Fabric Dataflows Gen2 And Concurrent Evaluation, Part 3: Is More Parallelism Always Good? →

By Chris Webb Dataflows, Fabric , Performance Tuning comments Read More
31 May

Fabric Dataflows Gen2 And Concurrent Evaluation, Part 2: Partitioned Compute

In the first part of this series I showed how the Concurrency setting in a Fabric Dataflows Gen2 can affect refresh performance when there are multiple queries inside the dataflow. In this post I will show how, with Partitioned Compute, this setting can also affect the performance of a single query within a dataflow. To … Continue reading Fabric Dataflows Gen2 And Concurrent Evaluation, Part 2: Partitioned Compute →

By Chris Webb Dataflows, Performance Tuning , comments Read More
24 May

Fabric Dataflows Gen2 And Concurrent Evaluation, Part 1

Did you know that if your Fabric Dataflows Gen2 contains several queries then you can control how many of them are evaluated in parallel when your dataflow refreshes? In this series I’ll look at how how you can do this and how it may result in better performance – at least in some cases. Let’s … Continue reading Fabric Dataflows Gen2 And Concurrent Evaluation, Part 1 →

By Chris Webb Dataflows, Performance Tuning , comments Read More
17 May

Understanding The “You’ve Exceeded The Capacity Limit For Dataset Refreshes” Error in Power BI

If you have a lot of Power BI semantic models that are scheduled to refresh at the same time in the Service then you may find that some of them fail with the following error: You’ve exceeded the capacity limit for dataset refreshes. Try again when fewer datasets are being processed. [Note: “dataset” is the … Continue reading Understanding The “You’ve Exceeded The Capacity Limit For Dataset Refreshes” Error in Power BI →

By Chris Webb Power BI, Refresh , comments Read More
10 May

Power BI Semantic Model Memory Errors, Part 5: The “Maximum Allowable Memory Allocation” Error

This is a very late addition to the series of posts I wrote back in 2024 and which started here on Power BI memory errors. It’s about a very rare error that is hard to deal with and often temporary but since people do run into it from time to time I decided to write … Continue reading Power BI Semantic Model Memory Errors, Part 5: The “Maximum Allowable Memory Allocation” Error →

By Chris Webb Power BI, , comments Read More
03 May

Connecting Power BI Semantic Models To Data Sources Automatically With Binding Hints

Did you know that you can configure your Power BI semantic model so that it automatically binds to a data source connection when you publish? To illustrate how to do this, I created an Import mode Power BI semantic model in Power BI Desktop connected to the Products table in the ContosoSales sample database in … Continue reading Connecting Power BI Semantic Models To Data Sources Automatically With Binding Hints →

By Chris Webb Power BI, Power BI Desktop , Shareable Cloud Connections comments Read More
26 Apr

Generating Sample Data In Fabric Dataflows With FabricAI.Prompt()

Back in December the FabricAI.Prompt() M function was released in Fabric Dataflows Gen2. Most of the people writing about it at that time, as in this great post by my colleague Sandeep Pawar, focused on calling this function for each row in a table – something that the UI in the editor makes easy. However … Continue reading Generating Sample Data In Fabric Dataflows With FabricAI.Prompt() →

By Chris Webb Dataflows, Fabric , M comments Read More
12 Apr

Power BI And Support For Third Party Semantic Models

I’ve been working with Microsoft BI tools for 28 years now and for all that time Microsoft has been consistent in its belief that semantic models are a good thing. Fashions have changed and at different times the wider BI industry has agreed and disagreed with this belief; right now, semantic models are cool again … Continue reading Power BI And Support For Third Party Semantic Models →

By Chris Webb Power BI, Semantic Layers , comments Read More
05 Apr

Role-Playing Dimensions In Fabric Direct Lake Semantic Models Revisited

Back in September 2024 I wrote a blog post on how to create multiple copies of the same dimension in a Direct Lake semantic model without creating copies of the underlying Delta table. Not long after that I started getting comments that people who tried following my instructions were getting errors, and while some bugs … Continue reading Role-Playing Dimensions In Fabric Direct Lake Semantic Models Revisited →

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