Need to know refresh time for each object in dataset

[Narukkp]

Hi Team,
In my report i have 10 tables and now i want to know each table refresh time in power bi service instead of entire dataset refresh time. Is there way to identifiy each indidual object refresh time ?. I know we can able to see in  data flows but how i want in dataset level each object refresh time.
Note: we do not have SQL profiler level access and using DAX studio DMV unable to find out difference between Refresh end time and refresh start time 

[Anonymous]

Hi @Narukkp ,

There seems to be no way to get the refresh time of a single visual object. But if each visual object sources a dataflow, you can try to use this:

DateTime.ToText(DateTimeZone.RemoveZone(DateTimeZone.UtcNow())+#duration(0,8,0,0))

Converts to the approximate refresh time of the current time zone (in +8 zones, for example).

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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