I have a workbook having multiple dashboards, few of them are on HANA views and 1 on Microsoft SQL server. I was getting an error after publishing the workbook on tableau server (unable to access the data) later when checked I cam to know we have to take an extract of the data source and publish it to the tableau server but now after extract, I am trying to publish the workbook I am getting this error, do you have any idea how to get rid of this and resolve it?
This workbook cannot be published because one or more extracts have an impersonated database connection. Either remove the extract or change the authentication to not use impersonation.
Thanks in advance,
Under the data sources section of the publication window can you verify none of the data sources are set to "Impersonate" for their authentication type.
Hope this helps!