How to get Data Updated date from a PowerBI Dataset

[EshaanG]

I have connected to multiple PowerBI Datasets which are published by different teams in my org and all of them get refreshed at different frequencies. How can I get the dates on which these datasets were updated in my PowerBI report?

I want to get the below date which shows up when you open a PowerBI report on PBI Service in my report

[v-robertq-msft · Accepted solution]

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.

[selimovd]

Hey @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.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[EshaanG]

Hey @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_Admin]

In that case it would be time for your data source to have that same field.