Table Refresh duration on Power BI Service

[datajunkie_29]

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!

[cassidy · Accepted solution]

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.

[datajunkie_29]

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.

[cassidy]

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.