I have a Tableau dashboard on Tableau Server connected to PostgreSQL through a view. The view refresh is already embedded within the daily PostgreSQL processes and gets refreshed successfully every day.
However, the issue is that the Tableau dashboard data is not reflecting the latest refreshed data. The dashboard date updates correctly as T-1, but the actual data displayed is still from T-2.
Could anyone please help identify possible reasons for this behavior?
Additional Information:
- Data source: PostgreSQL View
- Dashboard refresh frequency: Daily
- View refresh is completed successfully in PostgreSQL
- Only the Tableau dashboard data appears delayed by one day
Could this be related to Tableau extract refresh, caching, or connection settings?
Hi, as explained before this is a cache problem.
What you can do besides what has already been explained?
a. If working directly into Tableau Server/Cloud UI:
You can add to the end of your url the option :refresh=yes. E.g:
https://yourtableauserver.com/views/Date-Time/DateCalcs?:refresh=yesThen you can add to bookmarks the link in your browser, and you will avoid to pushing the refresh button.
b. If you are working with an embed scenario, then you can add a custom parameter to the embed code:
<tableau-viz id="tableauViz"
src='https://my-server/views/my-workbook/my-view'>
<custom-parameter name=":refresh" value="yes"></custom-parameter>
</tableau-viz>
If this post resolves the question, would you be so kind to "Accept this Answer"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego Martinez
Tableau Visionary and Tableau Ambassador
