Forum Discussion
Table Refresh duration on Power BI Service
Hello All,
Is there a way to get detail breakdown on refresh time for a dataset (time taken by each table in the datset during scheduled refresh)?
I found this post, but this helped me get the time taken by tables on Power BI Desktop.
When I refresh my dataset on local it takes less time to complete compared to service and that's the reason I want to see how much time each table is taking on service to optimize the dataset. Can we get the detail break-down by table on Service?
Any help is appreciated. Thanks in advance!
Yes! It's solution 4 in the post you linked. That solution monitors the activity during a Service Dataset Refresh, I use it all the time for what you are looking for.
3 Replies
Yes! It's solution 4 in the post you linked. That solution monitors the activity during a Service Dataset Refresh, I use it all the time for what you are looking for.
Thank you cassidy for your response I'll go ahead and test it out but just a quick question, the SQL server profilier would work irrespective of the datasource right? Does it only work with SQL server? As my datasource is Snowflake.
Your Datasource in this instance is the Dataset itself refreshing on Service. The blog post does a good job of walking through the steps to set it up and you'll see that you'll be connecting to Analysis Services with your Datasets connection string.
