KNOWLEDGE BASE

Unable to Add "Saved Credntial" for "Azure Synapse Analytics"


Published: 15 Apr 2022
Last Modified Date: 09 Dec 2022

Issue

After adding Azure Synapse Analytics saved credentials, even after a successful login on the Azure AD side, the saved credentials would not be added without error.

Environment

  • Tableau Server
  • Configure Azure AD for OAuth and Modern Authentication

Resolution

Option 1

Configure "Secret Value" as a value of OAuth client secret ("oauth.config.client_secret").
For example, configuring the "Secret ID" instead will cause this issue.


Option 2

Make sure that the value of the configuration ID ("oauth.config.id") corresponds to Database.
For example, when using Azure SQL Database, "azure_sqldb" is expected. "azure_sql_sqldb" will cause this issue.

Cause

The issue occurs when one of the OAuth Client Secret configuration parameters is incorrect.
 

Additional Information

The error of the OAuth process can be found in vizportal_0.<build number>\logs\oauth-service.log.
Did this article resolve the issue?