Improving Performance of Pages in Power BI
July 30, 2018
There are several tricks for improving the response time of your Power BI pages. On of the easiest methods to implement is to limit your table visualizations to a certain number of rows.
By doing this, the visualization renders quicker and it helps your users focus on the most important data points.
There is an option to sum up all the other rows beyond the top N in a category called other, but that will also slow down your performance.
It requires using the Rankx function, which, as admitted by Microsoft’s own blog is the slowest function available in Power BI.
It’s important to evaluate the trade off between performance and functionality when designing your dashboards.
About The Author
