Forum Discussion
PowerBI report load time SLAs
Hi, MadhavB
Defining SLAs for Power BI report load times is an important aspect of ensuring a good user experience. Here are some considerations for setting these SLAs.
Report complexity, Load times may vary depending on the complexity of the report. Detailed table visual objects with many rows and columns may take longer to load than trend charts with aggregated data. It is common to set different SLAs for different types of visual objects.
Data Model Size, The size of the Power BI dataset may affect load time. Larger datasets may take more time to process and render visual objects.
User Expectations, It is critical to understand the expectations of end users. Some users may be more tolerant of longer load times for complex reports, while others may want fast access to data.
Performance Best Practices, Implementing best practices such as using aggregation, optimizing DAX queries, and reducing the number of visual objects on a report can help reduce load times.
1. There is no one-size-fits-all answer for standard SLAs, as it depends on the factors mentioned above. However, a common benchmark for interactive reports is to aim for a load time of 10 seconds or less. For more complex reports, load times may be longer, but be sure to set expectations with your users accordingly.
2. The amount of data displayed on the report visual object and the size of the dataset can affect load time (if the computer is under-configured, the DAX statement is complex, and the amount of data on the visual object is too large, the content displayed on the report visual object will load slowly or not even load)
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi, MadhavB
Defining SLAs for Power BI report load times is an important aspect of ensuring a good user experience. Here are some considerations for setting these SLAs.
Report complexity, Load times may vary depending on the complexity of the report. Detailed table visual objects with many rows and columns may take longer to load than trend charts with aggregated data. It is common to set different SLAs for different types of visual objects.
Data Model Size, The size of the Power BI dataset may affect load time. Larger datasets may take more time to process and render visual objects.
User Expectations, It is critical to understand the expectations of end users. Some users may be more tolerant of longer load times for complex reports, while others may want fast access to data.
Performance Best Practices, Implementing best practices such as using aggregation, optimizing DAX queries, and reducing the number of visual objects on a report can help reduce load times.
1. There is no one-size-fits-all answer for standard SLAs, as it depends on the factors mentioned above. However, a common benchmark for interactive reports is to aim for a load time of 10 seconds or less. For more complex reports, load times may be longer, but be sure to set expectations with your users accordingly.
2. The amount of data displayed on the report visual object and the size of the dataset can affect load time (if the computer is under-configured, the DAX statement is complex, and the amount of data on the visual object is too large, the content displayed on the report visual object will load slowly or not even load)
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
To follow up on the original posters question - once you have established what you SLAs are - how do you measure them for the reports, and track performance, get notified when they are missed, etc? I have looked at the "Report usage Metricds Report" and while it doesn't seem to show End User Experience metrics. Could you recommend a good way to find where that data is recorded and surface it?