Is there anyway to add Last Refresh Date-time of Power BI Datasets in Power BI Report..?

[Anonymous]

Hi All,

I have Power BI Report and source of this report is Azure Blob. On the Datasets (Only one datasets and no gateway involved), I have schedule refreshs (at 5 different timings). I want to display last Refreshed Datetime of datasets on Report. 

How can i do this..?

[Anonymous · Accepted solution]

Hi @Anonymous,

You can add a query table to your raw pbix file to invoke rest api to get th refresh info from the dataset which you published to power bi service side. Then you can publish the new version to replace the original report.

Announcing Data Refresh APIs in the Power BI Service 

Capacities - Get Refreshables 
Regards,

Xiaoxin Sheng

[amitchandak]

@Anonymous ,refer if these can help

https://www.enhansoft.com/how-to-add-the-last-refreshed-date-and-time-to-a-power-bi-report/

[lbendlin]

You are chasing the wrong goal.  Instead of the Last Refresh Date you will want to have a Last Modified Date in your dataset that you then use for the UX.  Last Refreshed Date is largely meaningless as the dataset refreshes will happily process old data over and over.