Report Server on web view visual loading

tangutoori — Wed, 13 Nov 2024 10:56:53 GMT

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.

Re: Report Server on web view visual loading

lbendlin — Wed, 13 Nov 2024 11:24:41 GMT

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

Re: Report Server on web view visual loading

Anonymous — Fri, 15 Nov 2024 05:51:32 GMT

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 Power BI Blog | Microsoft Power BI

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 Power BI

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.

topic Report Server on web view visual loading in Report Server

Report Server on web view visual loading

Re: Report Server on web view visual loading

Re: Report Server on web view visual loading