Refresh date for each table separately

[Anonymous]

Hello!

I'm looking for solution that allows me to show last refresh time per each table separately.

Sometimes I refresh only one table in report and for each one I want to store another refresh date.

Could you please share some solution with me?

Thanks

[sturlaws]

Hi @Anonymous ,

if your sources are e.g. SQL Servers, you can add a time stamp column in you queries.

If that is not possible, you can create a time stamp-column in Power Query/Edit queries:
In Power Query, add a custom column and use the function DateTimeZone.LocalNow():

This column will be updated every time you refresh the data. But it will also be updated whenever you work with the table in Power Query.

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.