Forum Discussion
Kudo CommanderStrategies to reduce paginated report initial load time?
Hi MarkPalmberg
The slow load time of your paginated report in Power BI Service (75 seconds to load parameters) may be due to slow-performing SQL queries in the stored procedure or dynamic parameter queries fetching large datasets. To improve performance, optimize the stored procedure by reviewing indexing and query execution on Azure SQL Server. Limit dynamic parameters or use static pre-populated values to reduce load time. Ensure your Azure SQL Server is using a high-performance tier, and enable data caching in Power BI Premium for quicker report generation. Reducing the number of parameters and checking Power BI's premium capacity settings for potential bottlenecks will also help. Ensure that both Azure SQL Server and Power BI Service are in the same region to minimize network latency. Regularly monitor resource usage with Azure Monitor to detect any issues.
Community SupportHi MarkPalmberg ,
Thank you for reaching out to us on the Microsoft Fabric Community Forum.
Here are few suggestions to reduce the load time of your paginated report:
Simplify the report layout and minimize the number of parameters to improve initial load time.
Optimize queries by using indexes and maintaining up-to-date statistics to enhance data retrieval efficiency from your Azure SQL Server.
Here is the documentation link that may help to resolve your query:
Paginated reports in the Power BI service - Power BI | Microsoft Learn
If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.
Regards,
Menaka
- v-menakakota
Hi MarkPalmberg ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Regards,
Menaka.- v-menakakota
Hi MarkPalmberg ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.