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

[Anonymous]

Got it, thanks.

Thanks,
Lawrance A