Forum Discussion
Helper IHow to get Data Updated date from a PowerBI Dataset
Hi, EshaanG
According to your requirement, I found an official document that uses the FixedUtcNow() function to get the last refresh date, you can take a look:
https://docs.microsoft.com/en-us/azure/devops/report/powerbi/add-last-refresh-time?view=azure-devops
Here’s a blog that describes a method that uses API to collect the current PST Date/Time, you can also have a try:
https://www.excelguru.ca/blog/2016/06/08/display-last-refreshed-date-in-power-bi/
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Most Valuable ProfessionalHey EshaanG ,
the easiest way to show that in a report is to add in Power Query a new table with one column and then just add the function "DateTime.LocalNow".
This you can display in the report and always contains the moment of the last refresh.
Helper IHey selimovd
Thanks for the response but this only gives me the last refresh date of my dataset. I want to fetch the last refresh date of a dataset which I am connected to. For e.g. I have a Sales PowerBI dataset which I connect to and that was refreshed on May 28th. How do I get the date in my report? Using the DateTime.LocalNow gives me my local date which is June 1st
Syndicate_AdminAdministrator
In that case it would be time for your data source to have that same field.