Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

All my reports are very slow in Power BI Report Server

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.

 

 

 

 

1 ACCEPTED SOLUTION
v-henryk-mstf
Community Support
Community Support

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:

vhenrykmstf_0-1632969144594.png

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.

View solution in original post

2 REPLIES 2
v-henryk-mstf
Community Support
Community Support

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:

vhenrykmstf_0-1632969144594.png

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
Solution Supplier
Solution Supplier

@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'

 

ponnusamy_0-1632772274629.png

 

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.

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.