Improve Performance (Load/Opening) scorecard dashboard

[icassiem]

Good day,

i have a scorecard dashboard of 12 KPI, with 15 data sources ranging from salesforce, betsuite, zendesk, sharepoint doucment libraries, csv, etc and some cases dupllicating for merging data sources etc

and each of the12 kpi cards has like 5 kpi variances + 3 graphs visiauls to choose from + many measures that also control the colors . many filters etc

The issue, executive users has become frustrated and losing interest as its become to slow and combersome, example opening the report there are so many loading icons running for like a minute and select and filtering then again loading redering icon even though i set the compoinents interations to only the kpi coard

i am wondering is there a free tool, i can plug my pbix where it cam highlight me ways of perfromance improvement, like redundant measures, fiels  not used or better methods of calc  - anything to improve etc?

Please any ideas, the dashboard looks great, tells a sotry and adds value but losing my audiance as it feels like an operational report and the 30+ loading/rendering icons is just a put off

Regards

[v-sgandrathi · Accepted solution]

Hi @icassiem,

Thank you for providing the details of your scenario.

It is evident that you have dedicated significant effort to developing a comprehensive and insightful scorecard dashboard. The performance lag you are encountering, particularly with multiple visuals, filters, and data sources, is a common challenge in complex Power BI reports.

Use the Performance Analyzer in Power BI Desktop (View > Performance Analyzer) to measure how long each visual takes to render. It helps identify slow-performing visuals or DAX queries and highlights where optimization is needed. You can also export the results for further analysis, making it a useful first step in improving report performance.
Use Performance Analyzer to examine report element performance in Power BI Desktop - Power BI | Micr...

DAX Studio is a free external tool designed to help you analyze and improve your Power BI model. It allows you to find unused columns and measures, spot slow DAX queries, and identify memory-heavy relationships or fields with high cardinality. To get started, open your .pbix file, select External Tools > DAX Studio, and use the VertiPaq Analyzer to check table sizes, column usage, and model efficiency for more focused optimizations.
Use composite models in Power BI Desktop - Power BI | Microsoft Learn

If each KPI card includes multiple visual options, consider using bookmark navigation to toggle between visuals without rendering them all at once. This approach improves performance by reducing simultaneous visual loading.
Data reduction techniques for Import modeling - Power BI | Microsoft Learn

Thank you and continue using Micrsoft Fabric Community Forum.

[v-sgandrathi]

Hi @icassiem,

Just checking in -- have you had a chance to review and try the provided solution? Kindly share the status whenever you get a chance.

Looking forward to your response
Thank you.

[rohit1991]

Hi @icassiem 
To improve your Power BI dashboard’s performance, start with the free Performance Analyzer tool built into Power BI Desktop to identify which visuals are slow to load. Next, use DAX Studio and Bravo for Power BI (both free external tools) to find unused columns, heavy measures, and optimization opportunities in your PBIX file.

Remove any unused fields, limit the number of visuals per page, and try to use Power Query for transformations instead of calculated columns. These steps will help you pinpoint and fix performance bottlenecks so your scorecard loads faster and is more responsive for your users.

[WishAskedSooner]

Do you have formatting that is a fx of Measures? As much as I love this feature, I have noticed in the service that it is slow, both from initial loading of the page and the simple updating when users are clicking away in the report.

I would love to know what I can do to speed things up because I don't believe this has anything to do with Data Model size, DAX measure complexity, etc.

[icassiem]

Thank You @v-sgandrathi , @rohit1991 , @WishAskedSooner 

I used the performance analyzer, changed bookmarks to use the navigator, less calcualed column and removed unused fields. 

There's an improvement, probably a 20% which is good