Data modelling and DAX
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
Introduction For this blog, I want to share an interesting approach that can potentially speed up slow reports that include a distinct count calculation. The approach described in this article explains how you can add a DIY version of an approximate distinct count calculation to a DAX based model. The method combines a little pre-processing … Continue reading DAX : Approx Distinct Count
This post is the last in this series (for now) and describes a technique used to enhance performance in Power BI models that use Aggregate Awareness. I hope you’ve enjoyed the series as much as I have writing and sharing. I will no doubt add more articles in the future but need to pause this … Continue reading Creative Aggs Part VI : Shadow Models
I wasn’t originally planning on including an article on Incremental Aggs as part of this series, but I like the idea, and it seems like a good fit for the series, so here goes. The series so far Introduction to Aggs Horizontal Aggs Mixing Agg and base table to produce a single value Accordion Aggs … Continue reading Creative Aggs Part V : Incremental Aggs
