Forum Discussion
biuser98
Helper II
Helper IIProcessing data with SSMS takes too long
I am trying to process a partition in SSMS which is connected to my dataset in pbi service. The partition contains around 55 million records. My source system has already completed the query. SSMS ke...
biuser98Helper II
Helper IIThe response time at the data source takes around 7 minutes to fetch all the rows for this particular year. How can i monitor the current resource utilization?
marcosvin
Resolver II
Resolver IIIf you are a capacity admin, you can install the Premium metrics app, which provides more detailed information: https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-metrics-app
There may be other concurrent tasks like yours competing for resources, and this is causing the slowdown.
- biuser98
I checked the metric app, nothing special. All seems normal. I tried to load a partition, it finished in 2 hours.. for just 50 million records. How to speed this up?