cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Dataflows Last Refresh Date?

Hi,

 

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

 

Thanks,

Lawrance A

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

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


View solution in original post

6 REPLIES 6
Highlighted
Super User III
Super User III

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

Highlighted
Anonymous
Not applicable

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

 

Thanks,

Lawrance A

Highlighted

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


View solution in original post

Highlighted
Anonymous
Not applicable

Got it, thanks.

Thanks,
Lawrance A
Highlighted

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

Highlighted
Helper I
Helper I

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. 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors