Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear community,
I would like to ask, how long a report page is loading in average. We have multiple reports implemented in a customer environment and some pages react directly, on others there is a latency of 3 to 9 seconds. We already have minimized the visuals and measures, but some are necessary.
We mostly have to different kinds of report pages:
We made the experience, that these sliders load quite long, but then other visuals or even textboxes are loading, too. Even if all interactions are deleted.
Maybe you have some tips and tricks or an expert can tell me, if there is a known latency in the service like "All sliders need at least 2 seconds for loading because of something in the background" or "We are working on the loading time for visuals and it will be better with the next release" or .. you know what I mean.
Thank you in advance.
p.s.: We already use a Power BI Premium capacity but this was not helpful at all.
Solved! Go to Solution.
Hi @Anonymous ,
If you use DirectQuery mode to connect data, your report performance depends largely on the performance of the underlying data source.
You can optimize your data model using following tips:
For more information on optimizing data sources for DirectQuery, see DirectQuery in SQL Server 2016 Analysis Services.
To minimize the impact of network latency, strive to keep data sources, gateways, and your Power BI cluster as close as possible. If network latency is an issue, try locating gateways and data sources closer to your Power BI cluster by placing them on virtual machines.
To further improve network latency, consider using Azure ExpressRoute, which is able of creating faster, more reliable network connections between your clients and Azure datacenters.
You can learn more via the link: https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance#optimize-your-model.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
To improve the performance , there are some tips you can considerate:
Enable Row-Level Security (RLS) where applicable
Use Microsoft AppSource certified custom visuals where applicable
do not use hierarchical filters
Provide data categorization for Power BI reports (HBI, MBI, LBI)
Use the On-premises data gateway instead of Personal Gateway
Use slicers sparingly
you can refer to the links to see more performance tips:
https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance,
https://blog.pragmaticworks.com/power-bi-performance-tips-and-techniques,
https://maqsoftware.com/expertise/powerbi/power-bi-best-practices.
(Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.)
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Dear Amy,
checked all of your tips and rebuild pages of our report. Some things were helping (such as reducing visuals on a page again), other we already worked on (no custom visuals, no hierarchical filters, ..)
I checked all with the help of the Power BI integrated Performance Analyzer. May be you or anybody else can now tell me, how can I improve the field "Other"? DAX and direct query figures are fine, but I have to wait 2 to 4 seconds for "other" (sometime even up to 7 sec).
Thank you in advance and best regards
Hi @Anonymous ,
If you use DirectQuery mode to connect data, your report performance depends largely on the performance of the underlying data source.
You can optimize your data model using following tips:
For more information on optimizing data sources for DirectQuery, see DirectQuery in SQL Server 2016 Analysis Services.
To minimize the impact of network latency, strive to keep data sources, gateways, and your Power BI cluster as close as possible. If network latency is an issue, try locating gateways and data sources closer to your Power BI cluster by placing them on virtual machines.
To further improve network latency, consider using Azure ExpressRoute, which is able of creating faster, more reliable network connections between your clients and Azure datacenters.
You can learn more via the link: https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance#optimize-your-model.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.