Forum Discussion
Report Server on web view visual loading
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.
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.By following some best practices and optimizing your data model to reduce unnecessary columns and rows, you can improve the responsiveness of your reports.
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.
2 Replies
Sounds like your report server is underpowered or has a bad network connection? What are the characteristics of the machine?
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.By following some best practices and optimizing your data model to reduce unnecessary columns and rows, you can improve the responsiveness of your reports.
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.
