Forum Discussion

EshaanG's avatar
EshaanG
Icon for Helper I rankHelper I
5 years ago
Solved

How to get Data Updated date from a PowerBI Dataset

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

 

Need Help
Show and Tell

4 Replies

  • selimovd's avatar
    selimovd
    Icon for Most Valuable Professional rankMost Valuable Professional
    5 years ago

    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
     
    • EshaanG's avatar
      EshaanG
      Icon for Helper I rankHelper I
      5 years ago

      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's avatar
        Syndicate_Admin
        Icon for Administrator rankAdministrator
        4 years ago

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

  • v-robertq-msft's avatar
    v-robertq-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    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.