Loading

Connection to MS Azure and the Authentication Types

Дата публикации: May 7, 2025
Описание
Tableau Desktop is unable to connect to Microsoft Azure data sources using the following authentication types:
  • Active Directory Integrated Authentication
  • Active Directory Universal Authentication
  • Multi Factor authentication
Решение
The following are possible with Azure:
  • For Azure SQL databases, use SQL Authentication (which uses a username and password).
  • For Azure Analysis Services, create a guest (B2B collaboration) user account for use with Tableau. 
  • For Azure SQL databases, use the Active Directory password or Azure AD via OAuth as noted in the Tableau Online Help.
Дополнительные ресурсы

For more information about this topic, see the following documentation in the Microsoft Knowledge Base: 

Authentication and user permissions (Azure Analysis Services)
Azure SQL Database and SQL Data Warehouse access control

When logging in to Azure Analysis Services in Tableau Desktop using Active Directory Universal Authentication, the following error may occur: 

An error occurred while communicating with the Microsoft Analysis Services data source 'asazure://<url>'. 
Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database. 
Database error 0x80004005: COM error: COM error: mscorlib; Exception has been thrown by the target of an invocation.. 
Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database. 

Additionally, to voice your support for the future implementation of such a feature, please vote on the following Community Ideas: 
Azure Integrated Authentication
Allow Azure Analysis Services with SSO

Error "[Simba][SqlServerODBC] (15) Failed to connect to the SQL Server instance: [28000]" Connecting to Azure SQL on Mac
Номер статьи базы знаний

001498382

 
Загрузка
Salesforce Help | Article