Get Model/Refresh Run Date for whole Data Model

[joshua1990]

Hello everyone! I would like to elaborate/ develop a page that contains every table of the report and shows the corresponding refresh date. Is there some elegant approach to do this automatically? I think these data is within the meta data, right? Of course, I could add for every table a new column and place there the model run date. But maybe it’s much more easier? Best regards

[lbendlin]

You are solving the wrong problem.  The refresh date is largely meaningless, it is just eye candy.  What you really need is something like a "Last ModifiedDate" in each of your data sources, in the actual data, not in the meta data.

[joshua1990]

@lbendlin : Thank you so much for your reply!

What is the difference between the last modified date and the refresh date?

And how would you build that?

[lbendlin]

Last modified:  when your data was last touched (insert/update)  (NOTE: would not cover deletions!)

Last refreshed:  when Power BI last processed the dataset

Imagine you have 2019 Sales data that doesn't change.  You set it to refresh in Power BI every day.  That is totally useless, and a waste of resources.  If on the other hand you keep modifying that data (returns, for example, or legal disputes) then refreshing the dataset makes sense.

You cannot build this (Last modified date) in Power BI, it has to be part of your upstream data source.