Intro to Power BI Aggregations

This article introduces the Power BI User-defined Aggregations feature. It includes a walkthrough example (with video) showing how to configure and test a simple model to use this feature. If you have not used Power BI User-defined Aggregations before, need a refresher or reminder, or are just keen to understand how to configure, this article Continue reading Intro to Power BI Aggregations

Power BI – Pause/Resume calculations with Apply All feature

Power BI doesn’t yet have a feature that allows end-users to turn on/off the ability to process calculations for visuals on a report page until they are ready. Most of the time, this is perfectly fine – however, in some instances, it can be handy to disable long-running and heavy calculations from running. At the Continue reading Power BI – Pause/Resume calculations with Apply All feature

Use Bookmarks to lazy-load Power BI Visuals

When Power BI loads a report page, it fires a query for every visible visual on the page. For some pages, this can result in a large number of queries all fired simultaneously at the underlying database. This load can cause quite a bit of contention, and in some cases, will slow down the overall Continue reading Use Bookmarks to lazy-load Power BI Visuals