Add Data refresh date of a PBI dataset to a report

[newpbiuser1_23]

Hi, 

Is there any way to display the refresh date of a published PBI dataset in a report? The PBI dataset is not refreshed everyday, but the requirement is to show users the last refreshed date of the data.  The option to display refresh date using blank query does not work because I cannot create a blank query when connecting to a PBI dataset. I saw another post where the suggestion was to create a tile in a Dashboard, but that does not fit my requirements. Is there any way to do this? Appreciate your suggestions!

[v-easonf-msft · Accepted solution]

Hi, @newpbiuser1_23 

Sorry. As of now ,you cannot add additional queries to the data source to get the last refresh time as your data source is "dataset", which belongs to the connection mode of liveconnect.

If you are the owner of the original data model, you can consider adding a calculated column/ or a new table in M, that when loaded to the model will give you the refresh time.

How-to-include-the-Latest-Refresh-date-and-time-in-a-report 

Best Regards,
Community Support Team _ Eason