I updated the Athena DB connection credentials (username/password) in a Tableau workbook, and the extract refresh was working successfully after the update.
After around 5 days, I performed a web edit on the dashboard and made some changes. During this process:
- Tableau did not prompt for credentials
- While republishing, only the “Embed credentials” option was available
However, after republishing the workbook, the scheduled extract job started failing with an incorrect username/password error.
This is confusing because the credentials were already updated earlier and were working fine before the web edit.
My queries:
- Why is Tableau not asking for credentials during web edit or republish?
- Does web edit/republish overwrite or remove previously saved credentials?
- Why would the extract fail with incorrect credentials even though they were updated earlier?
- Is there any known limitation or behavior with Athena connections in such scenarios?
- does role affect?
#Tableau Server #Tableau Public #Tableau Desktop & Web Authoring #Tableau Cloud #Tableau #Tableau APIs & Embedding #Tableau Community Updates
dealing with WebEditing and credentials can be a bit unstable. I've seen a lot of instances over the years were credentials for some mysterious reasons were not committed or using old ones or using credentials from another tenants while the Analysts were working daily on multiples tenants.
This is one example:
https://help.salesforce.com/s/issue?id=a02Ka00000lYbc8IACAs you seem to work with embedded data source directly in the workbook, as Diego said in his earlier post, use published data sources. To keep your datasource stable and modify your workbook content irrelevant of Athena connections even in WebEdit.
And ideally you modify your published data sources using Tableau Desktop if you can.