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

DAX : Approx Distinct Count

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