如何在Tableau Desktop中显示数据源刷新日期？

Hey there! I’ve dealt with this exact requirement before, so let me share a few practical ways to display your data source’s refresh date in Tableau:

1. Use the built-in field for Extract data sources #

If your data source is an Extract (.hyper file), Tableau has a hidden built-in function that’s perfect for this:

• Create a calculated field and enter the formula: LAST_REFRESH_DATE()
• This function will directly return the last refresh timestamp of your extract. You can drag it to a text object, dashboard title, or a corner of your view to display it clearly.
• Note: This only works for Extracts—real-time connections won’t recognize this function.

2. Custom field for real-time data connections #

For real-time connected data sources, you’ll need to add a refresh date tracking field directly to your underlying data:

• In your original database/ETL pipeline, add a field like data_refresh_timestamp. Update this field to the current datetime every time your data is refreshed (via scheduled scripts, ETL tools, etc.).
• In Tableau, pull this field into your view and use the calculation MAX(data_refresh_timestamp) to get the latest refresh time (since all rows should have the same value, MAX will return the single, most recent timestamp).

3. Leverage Tableau Server/Online Metadata API (for published dashboards) #

If your dashboard is hosted on Tableau Server or Online, you can pull refresh details via the Metadata API:

• For more technical users, create a calculated field or use Tableau Prep to call the API and fetch the refresh date of your published data source.
• As a quick workaround, you can also grab the "Last Refreshed" timestamp from the data source’s details page on Tableau Server and embed that info (via a text box or screenshot) into your dashboard.

Bonus tip: If you use Tableau Prep to clean or transform your data, you can add a custom field in Prep that captures the current datetime when the flow runs. Bring this field into Tableau Desktop, and you’ll have a reliable refresh date to display.

内容的提问来源于stack exchange，提问作者Bruno Agustoni