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 ...
Need Help
Show and Tell
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.