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.
Super UserHi MarkPalmberg
What would happen if you had to remove the parameters from your header just to see if that is where the actual issue is? Because if it is, then additional way to start working to see how to reduce that. It could potentially be that you've got to use nested parameters so that one will be through to the other parameter instead of one large or long query running?