Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Refresh date for each table separately

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

Need Help

1 Reply

  • sturlaws's avatar
    sturlaws
    Resident Rockstar
    6 years ago

    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.