Our requirement is:
- The dashboard (or extract) should refresh only when the latest data for the same day is available at backend DB (for example, based on the presence of a success file or updated data in the source).
- If the updated new data is not yet available, the refresh should not RUN but instead wait and retry in the next cycle.
We would like to understand:
- Is it possible in Tableau Server to trigger refreshes based on a success file or data availability check?
- What are the recommended approaches to avoid unnecessary refresh failures when the source data is delayed?
- Any guidance, best practices, or implementation examples would be highly appreciated.
#Tableau Desktop & Web Authoring #Tableau Public #Tableau Server #Tableau Cloud #Tableau #Tableau APIs & Embedding
3 answers
,
I agree with
@Emeric LE SAULNIER DE SAINT JOUAN. I f you want to achieve this, your best bet is to trigger the refresh as part of your data loading pipeline.
You can trigger a refresh using Tableau REST api and/or the python library tableauserverclient:
There are lots of examples available.
https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api.htm
https://tableau.github.io/server-client-python/To trigger the refresh, the easiest is to get a list of data sources with a specific tag, and then loop through this list and trigger a refresh for each. Then you can maintain the extracts to be updated easily inside Tableu just using tags.
