Improve Speed of PowerBI Service Load

[Anonymous]

I have a dashboard posted to the online service as in the screenshot:

Ther are about 150 of those circles.  Each one of those circles is linked to a tab that has data displayed from an individual table, and we only really click on the circles that are red.  If you clicked on a red circle, it brings you to a visual data table that has some lines of data.  If you click on a green circle, it brings you to a visual table that is empty.  These tables are all direct queries to SQL server and are updated about every 15 minutes.  So the circles can go from green to red and vice versa throughout the day.

In the online service, if you click on a red circle, the corresponding visual table it takes you to with data lines loads prertty quickly.  On each data table visual, there is a button to bring you back to the main page that is in my screenshot.  When you click that button to go back, the page with all the circles takes a long time for each circle to load and appear.  Is there any way to increase the load time.  With what we need this for, I don't know if I can really decrease the visuals.  If I run a performance analyzer when I go to the main page to load, pretty much all the time taken for each circle is under the other category.    

[Anonymous]

Hi @Anonymous ,

Based on the information you’ve provided, it seems that the issue is with the load time of the data tables in Power BI. Here are some steps you can try to increase the load time:

Optimize your data model: Ensure that your data model is optimized for performance. You can use the Performance Analyzer in Power BI Desktop to identify any performance bottlenecks in your data model and take corrective action.

Use incremental refresh: If your data is updated frequently, consider using incremental refresh to improve performance. Incremental refresh allows you to refresh only the most recent data, reducing the amount of data that needs to be refreshed and improving performance.

Use DirectQuery: If your data is too large to load into memory, consider using DirectQuery mode. DirectQuery mode allows you to query your data source directly, without loading the data into memory. This can improve performance for large datasets.

Optimize your SQL Server: Ensure that your SQL Server is optimized for performance. You can use the SQL Server Profiler to identify any performance bottlenecks in your SQL Server and take corrective action.

Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Learn

Improve Power BI Refresh Time & Performance (enterprisedna.co)

Configure incremental refresh and real-time data for Power BI datasets - Power BI | Microsoft Learn

Chris Webb's BI Blog: Speed Up Data Refresh Performance In Power BI Desktop Using Table.View (crossjoin.co.uk)

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.