Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
How to show Dataflows Last Refresh Date in Power BI Report?
Thanks,
Lawrance A
Solved! Go to 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
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.
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
I tired the script but it showing current data time instead of Dataflow last refresh date.
Thanks,
Lawrance A
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |