Report Server on web view visual loading

[tangutoori]

Hello Team,

We have excel as source for our Power BI dashboard.When we pusblish the file in the server and try to view them but visual are taking 2 minutes to load. Even after the load to retive data as per slicer seleciton it's also slow.

Can you please suggest some thoughts to improve the  performance.

Regards,

Narender.

[Anonymous · Accepted solution]

Thank you lbendlin 

Hi,  @tangutoori 

To improve performance, I recommend that you consider the following:
With Power BI's query parallelization feature, you can dramatically improve dataset performance in DirectQuery mode. This means that multiple queries can be processed at the same time, resulting in faster loads.

Query parallelization helps to boost Power BI dataset performance in DirectQuery mode | Microsoft Po...

 

By following some best practices and optimizing your data model to reduce unnecessary columns and rows, you can improve the responsiveness of your reports.

Best practice rules to improve your model’s performance | Microsoft Power BI Blog | Microsoft ...

 

Using Power BI's Performance Analyzer tool, you can identify which visuals or DAX formulas are causing performance bottlenecks so you can make targeted optimizations.

Optimization guide for Power BI - Power BI | Microsoft Learn

Boost Power BI Efficiency with DAX Optimizer - SQLBI

Introducing the Power BI Performance Analyzer - SQLBI

 

If you're using card visuals in your reports, make sure they're designed to be clean and avoid too many complex calculations, which can reduce load times.

Optimizing card visuals in slow Power BI reports - SQLBI

Optimizing DAX expressions involving multiple measures - SQLBI

These methods can help you improve the loading performance of your reports.

Best Regards

Jianpeng Li

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

[lbendlin]

Sounds like your report server is underpowered or has a bad network connection?  What are the characteristics of the machine?