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

When Can Partitioned Compute Help Improve Fabric Dataflow Performance?

Partitioned Compute is a new feature in Fabric Dataflows that allows you to run certain operations inside a Dataflow query in parallel and therefore improve performance. While UI support is limited at the moment it can be used in any Dataflow by adding a single line of fairly simple M code and checking a box … Continue reading When Can Partitioned Compute Help Improve Fabric Dataflow Performance? →

By Chris Webb Dataflows, M , Performance Tuning comments Read More
08 Mar

A Closer Look At Preview-Only Steps In Fabric Dataflows

I have been spending a lot of time recently investigating the new performance-related features that have rolled out in Fabric Dataflows over the last few months, so expect a lot of blog posts on this subject in the near future. Probably my favourite of these features is Preview-Only steps: they make such a big difference … Continue reading A Closer Look At Preview-Only Steps In Fabric Dataflows →

By Chris Webb Dataflows, Fabric , M comments Read More
01 Mar

Report On SAP And Salesforce Data In Fabric With Business Process Solutions

If you want to build a reporting solution on SAP (S/4HANA or ECC) or Salesforce data in Fabric and don’t want to build everything from scratch then you should check out Business Process Solutions. It’s a free, Microsoft-developed solution currently in public preview; the announcement blog post from last year is here and you can … Continue reading Report On SAP And Salesforce Data In Fabric With Business Process Solutions →

By Chris Webb Fabric, , comments Read More
22 Feb

Power BI, Parallelism And Dependencies Between SQL Queries In DirectQuery Mode

This is going to sound strange, but one of the things I like about tuning Power BI DirectQuery semantic models is that their generally-slower performance and the fact you can see the SQL queries that are generated to get data makes it much easier to understand some of the innermost workings of the Power BI … Continue reading Power BI, Parallelism And Dependencies Between SQL Queries In DirectQuery Mode →

By Chris Webb DAX, DirectQuery , Power BI comments Read More
15 Feb

Measuring Power BI Report Page Load Times

If you’re performance tuning a Power BI report the most important thing you need to measure – and the thing your users certainly care about most – is how long it takes for a report page to load. Yet this isn’t something that is available anywhere in Power BI Desktop or in the Service (though … Continue reading Measuring Power BI Report Page Load Times →

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