Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Dataflows Last Refresh Date?

Hi,   How to show Dataflows Last Refresh Date in Power BI Report?   Thanks, Lawrance A
Need Help
  • Mariusz's avatar
    Mariusz
    7 years ago

    Hi Anonymous,

    Sorry, I should have been clearer.

    You need to add the code to yor dataflow, so when the dataflows is refreshed it will give you the execution time. 

    Hope this helps

    Mariusz


MarkSL's avatar
MarkSL
Helper V
6 years ago

Hey Mariusz 

 

I've just used your script to allow us to pull through the last refresh time of our dataflow - however do you know how to convert and report it in the service as UK time?

 

I've found this post which looks like it does the above, however the last post states:

 

This solution works in desktop but does not work when you publish the report to the service. Any ideas on a fix? (I know the Service goes by UTC time)

 

Thanks

 

Mark

SofBL's avatar
SofBL
Advocate II
8 months ago

this learn page is about capturing the time of a refresh 
https://learn.microsoft.com/en-us/powerquery-m/m-local-fixed-utc-variants

the service is always in UTC so use switch zone to bring it to your local timezone.. or if you have users around the globe, use DAX TIME function with variable that gives the option on the report to select a timezone.


let
UtcNow = DateTimeZone.FixedUtcNow(),
LocalNow = DateTimeZone.SwitchZone(UtcNow, 3)
in
LocalNow

So my advise is always use the UTC variants when developing because in the end you bring your query to the service and on that moment it becomes UTC anyway. Everything not in UTC is basicaly volatile and an unreliable anchoring point.. The local time is nothing more than an offset to UTC depending on where you want to be.