Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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!
Solved! Go to 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.
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.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!