Generating Excel Reports With Fabric Dataflows Gen2
So many cool Fabric features get announced at Fabcon that it’s easy to miss some of them. The fact that you can now not only generate Ex...
5 days ago
Chris Webb's BI Blog Chris Webb's BI Blog
Query Folding And Staging In Fabric Dataflows Gen2
A few years ago I wrote this post on the subject of staging in Fabric Dataflows Gen2. In it I explained what staging is, how you can enable it...
12 days ago
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 the...
19 days ago
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 t...
26 days ago
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 s...
1 month ago
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 ...
1 month ago
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 c...
1 month ago
New Books: “The Definitive Guide To DAX” 3rd Edition And “Microsoft Power BI Visual Calculations”
For some reason I haven’t had any free copies of books to review recently; maybe the market for tech books has finally collapsed with AI...
1 month ago
New Performance Optimisation for Excel PivotTables Connected To Power BI Semantic Models
Some good news: an important optimisation has rolled out for Excel PivotTables connected to Power BI semantic models! Back in 2019 I wrote abo...
2 months ago
Calculate(), DAX Fusion And Filters On 0 In Power BI
Here’s a fun DAX performance tip that I found this week. Do you have measures that use Calculate() with a filter on a numeric column? Is...
2 months ago
