Dataflows Last Refresh Date?

[Anonymous]

Hi,

How to show Dataflows Last Refresh Date in Power BI Report?

Thanks,

Lawrance A

[Gregory_Felton]

You can also follow the steps in this video to get that last refresh date of a dataflow: https://youtu.be/Qe7exs9i_ww 

They just added this api. 

[Mariusz]

HI @Anonymous 

Add this is M script that I use

let
Source = #table(type table [#"dataflow last refresh"=datetime], {{DateTime.LocalNow()}})
in
Source

 Hope this helps
Mariusz

[Anonymous]

I tired the script but it showing current data time instead of Dataflow last refresh date.

Thanks,

Lawrance A

[Mariusz · Accepted solution]

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]

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]

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. 

[Anonymous]

Got it, thanks.

Thanks,
Lawrance A