When I've run into this problem it's usually been because we haven't set up access for tableau user to the data source but it looks like you have done that. Maybe check to see if the password for the tableau user has expired or is invalid.
Last month i published one dashboard(pointing to one database table ). When i access that dashboard, it is not asking me database credentials..It is working fine...
The new publish is using 3 or 4 views each pointing to different tables of same database. Now that it giving me errors.
Testing.zip 224.0 KB
Are those views in the same database as your tables? And do the views access any data outside of the database which has a tableau user set up?
Are your database tables published in tableau sever? While published there also you've to set the embedded credentials for each data source.
And instead of live you should first extract the data source and published to server when you first time connect the data source. Then create a schedule to refresh the data source. Then use the extract as live connection. You can refer this link for you reference. Don't know how much this help you.
Let me know If you've any query.