Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Dear all,
Is anything wrong today with Europe server cause almost all reports not working and are soooo slow ?
It was working perfect yesterday but today for no reason , not working as needed.
Kind regards,
Spyros
Solved! Go to Solution.
Close the case... The problem identified on Premium per user capacity.
Hi @SpiroswayGR ,
Premium per user capacity is a good way, to determine whether the report hosting capacity often exceeds the capacity resource or the Hourly Query Duration Distributions function to view the ratio changes between colors to identify slow reports , And through observation to determine the reason for the corresponding slowness, for example, long-term operation consumes CPU, causing new queries to wait or users with a large amount of concurrent capacity are using the same report or data set, etc.
There are also reasons for slow power bi services:
1. When the report is refreshed at the same time, the model used for refreshing will be loaded. Once there are a large number of models in the memory, the memory will be full, so the model generated by the subsequent refresh operation will not be loaded and enter the queued state. , So that the report will be slow to load or even fail.
You can check the refresh time by viewing the Refresh Summary and metric usage app, make a reasonable allocation, try to choose the free time to refresh, and divide the refresh time together with the refresh time to avoid the queues caused by too many people and occupying resources.
2. The location of the gateway installation can have a significant impact on your query performance. Try to make sure that your gateway, data source locations, and the Power BI tenant are as close as possible to each other to minimize network latency.
For information, you can refer to the following:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-deployment-guidance
3.This report uses a complex Dax function, consumes too much memory, or uses too much of this post, especially the use of RLS, it will increase the refresh time.
You can also use the power Bi performance analyzer to view the performance of each report element or DAX studio to track the measurements in the data model and find problems.
This is related content, hope you can get help:
https://docs.microsoft.com/en-us/power-bi/admin/service-premium-capacity-scenarios
https://docs.microsoft.com/en-us/power-bi/guidance/report-performance-troubleshoot
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-premium-monitor-capacity
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Close the case... The problem identified on Premium per user capacity.