Power BI Storage Modes for Aggregations

Introduction How to choose the correct storage mode for Power BI Tables. This article aims to help explain the different storage modes available when designing an aggregation strategy for a Power BI Report. What each storage mode is and when you would use it. Picking the correct storage mode for each table in your model Continue reading Power BI Storage Modes for Aggregations

Power BI Multiple Aggregations tables

Part two in this series on Power BI Aggregation tables focuses on Power BI data models with more than one aggregation table. The first article introduced Power BI Aggregations and included a walk through configuring a Power BI model with a single aggregation table. Intro to Power BI Aggregations Multiple aggregations tables DUAL storage mode Continue reading Power BI Multiple Aggregations tables

Visualise your Power BI refresh – in real-time

Introduction I recently wrote an article showing how you can visualise a dataset refresh using Power BI. It was a pretty cool way to show some of the internal workings of what otherwise is a black box. The idea from my earlier article uses SSMS Profiler to run a trace against a database hosted in Continue reading Visualise your Power BI refresh – in real-time