All my reports are very slow in Power BI Report Server

[Anonymous]

Hi All,

All my reports loads very slow in PBI Report Server.

Even the smallest report with ( only 2 report pages and with very minimal calculation )  takes the same time to load as long as a larger report.

Any suggestions or solutions will be appreciated.

Thanks in advance.

[v-henryk-mstf · Accepted solution]

Hi @Anonymous ,

According to your description, I have two suggestions for slowness:
1. Power BI adds the ability to analyze the performance of Power BI desktop reports. This means that if your reports are running slowly, you can now use the Performance Analyzer on the Power BI desktop to identify the culprit and find the cause of the impact.
When you interact with the report, such as refreshing the visual effects, filtering the report, etc. The performance analyzer records all activities. If you have a long-running report, you can identify which vision is the culprit by looking at the running time.

2.Just like the reference system that Microsoft used for the tests, we recommend isolating the AD, SQL Server Database, Analysis Services (if applicable), & Power BI Report Server. Here is a sample reference architecture below:

For more details, you can read related document link:
Power BI Report Performance Analyzer - Ruki's Blog (rukiatu.com)

PowerBI Report Server Performance Tuning Best Practices (PBIRS) (gigxp.com)

Best Regards,
Henry

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

[ponnusamy]

@Anonymous : I would start with the following

- Check the server's resource using 'Resource monitor' on windows server

- If the resources are not fully consumed , check the server performance using 'Performance Monitor'

post your findings and we can troubleshoot further

If this post helps, then please consider Accepting it as the solution, Give Kudos to motivate the contributors.