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.
Hello! I've got a Power BI dataset set up on scheduled refreshes (8 refreshes per day, which is what the Pro license allows). For some reason, these refreshes will take vastly different amounts of time - 28 minutes, 91 minutes, 57 minutes, etc. I can't identify a pattern by day or time either (e.g. the 6:00am refresh takes 35 minutes one day, and 90 minutes the next day).
I'd like to know how I can diagnose why this is occurring?
Additional Details: The report is refreshing from an Azure SQL database connection. This database has no interactive users, and maintains a very consistent load throughout the day as it ingests a very consistent amount of IoT data from Stream Analytics. The only time the load spikes is when the Power BI refresh occurs. No users are manually refreshing the report during the scheduled refreshes.
Thanks for your reply! Some of the refreshes are overlapping, unfortunately. Most of the refreshes are scheduled one hour apart from each other, and sometimes they run over one hour. We could scale up the Azure SQL instance, but without knowing the underlying cause of the issue, I feel like that's just throwing money at the problem.
Refreshes cannot overlap. If a refresh is scheduled while another one is in progress then the scheduled refresh request will be dropped.
If you are not on a Premium SKU then you are sharing capacity with other customers. Their behavior impacts your performance in non-predictable ways.
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.