Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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

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 execut...
Need Help
Jonvoge's avatar
Jonvoge
Icon for Most Valuable Professional rankMost Valuable Professional
1 year ago

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 | Microsoft Learn).

_____________________________________________________
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