Dataset refresh - need breakup on Dataset refresh in Power bi Service .

[Anonymous]

Hi team, 
How can we know Breakup time for Datast refesh in Power bi Service..Let's say, Dataset has taken 7mins to complete refresh. So then how can we get breakup like how much is the query execution and PBI processing time.

[Anonymous]

Hi @Anonymous

In Power BI Service, getting a detailed breakdown of the dataset refresh time, such as the time spent on query execution versus Power BI processing, isn't directly available through the standard interface.

You can propose an idea about this, you can submit your idea by going to the link below.

Home (microsoft.com)

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jonvoge]

Hi Bajigntrr

I'm not sure such a breakdown exists.

You can programatically retrieve the status of completed and ongoing refreshes: Enhanced refresh with the Power BI REST API - Power BI | Microsoft Learn

But I do not believe they offer a break down of what happens during refresh.

If you are concerned about refresh duration (although 7 minutes is not that bad!), you can look into Incremental Refreshes (Incremental refresh for semantic models in Power BI - Power BI | Microsoft Learn), and for more advanced cases, managing the individual partitions incl. bootstrapping (Advanced incremental refresh and real-time data with the XMLA endpoint in Power BI - Power BI | Micr...).

_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data