Forum Discussion

Narukkp's avatar
Narukkp
Icon for Helper V rankHelper V
2 years ago

Need to know refresh time for each object in dataset

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 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.