Show Last Refresh of Semantic Model in Power BI Report

[lokeshb31]

Hi,

We aim to incorporate the last refresh of semantic model in Power BI report and followed article https://zebrabi.com/guide/how-to-add-refresh-date-in-power-bi/ to create a measure Last Refreshed = "Last Refreshed: " & FORMAT(NOW(), "dd/mm/yyyy HH:mm")

However tjis measure displays the latest date and time even during manual refreshes of visuals or when hitting the browser refresh. Can anyone help how to display the exact date/time in Power BI report when the semantic model was last refreshed?

[ibarrau]

Hi. Measures are processed at the moment you open the report to view the page. So if you run NOW, it will show now date. In order to keep the refreshed date of a semantic model, you can add a new query at Power Query editor asking for current date. The script getting the last date at power query will always run only when a refresh is run. So you can have the last date of the refresh inside the model.

Open Power Bi Desktop, add a blank query with the following code

DateTime.LocalNow()

That would bring datetime of the last refresh. If you just want date you can convert it with the function DateTime.Date()

Once you apply that, you can find a table with a column with one value on the model. The lastest refresh.

I hope that helps,

[markmsc]

I had the same question today, found your reply, and it worked like a charm.  Thank you!