Speed Up Dataflow Publishing/ Validation Times In Power BI And Fabric
If you’re working with slow data sources in Power BI/Fabric dataflows then you’re probably aware that validation (for Gen1 dataflo...
2 days ago
Chris Webb's BI Blog Chris Webb's BI Blog
Using Excel Solver With Power Pivot
After years of meaning to learn how to use Excel Solver, this week I’ve finally made a start: I want to use it to work out the optimal w...
8 days ago
Refreshing Hidden Tables In Power BI Semantic Models With Fabric Data Pipelines
Following on from my recent post about refreshing semantic models with Fabric Data Pipelines and the semantic model refresh activity, a few pe...
16 days ago
Another Way To Visualise Import Mode Semantic Model Partition Refresh Parallelism
I’m a big fan of Phil Seamark’s “visualise your refresh” pbix file, which allows you to analyse the different operatio...
23 days ago
Monthly Power BI Semantic Model Refreshes With Fabric Data Pipelines
I’m sure you already know how to configure scheduled refresh for your semantic models in Power BI. While the options you have for contro...
1 month ago
Reading Delta Metadata In Power Query
There’s a new M function rolling out now that allows you to read metadata from Delta tables (at the time of writing it’s available...
1 month ago
Improve Power Query Performance On CSV Files Containing Date Columns
A few weeks ago I replied to a question on reddit where someone was experiencing extremely slow performance when importing data from a CSV fil...
1 month ago
Limit The Impact Of Expensive Power BI Queries On Your Capacity By Reducing The Query Timeout
The recent announcement of Surge Protection gives Fabric/Power BI capacity admins a way to restrict the impact of background operations on a c...
1 month ago
Why DAX Is Better Than MDX For Bulk Extracts Of Data From Power BI
This is a post I’ve avoided writing for many years, and before I carry on let me make one thing clear: Doing bulk extracts of data from ...
1 month ago
TMDL View And Power BI Developer Productivity: An Example Using The Detail Rows Definition Property
For me the biggest new feature in the January 2025 release of Power BI Desktop is the new TMDL View; many other people like Marco are excited ...
2 months ago
