question

MSTechie-7364 avatar image
0 Votes"
MSTechie-7364 asked LukasYu-msft answered

Microsoft SSAS to Azure SQL using Azure AD Authentication or Managed Identity ?

As far as i can see, From Visual Studio 2019 for SSAS Cubes, it only supports Windows or SQL Authentication and not Azure AD Authentication or Managed Identity ?

Can SSAS MDX Cubes on Azure VM connect & fetch data from Azure SQL , using Azure AD Authentication or Managed Identity ?

Please help.

Note: Mine is MDX Cube which is not supported in Azure SSAS as of now. Hence using SSAS on Azure VM , instead of the PaaS option of Azure SSAS.

azure-sql-databasesql-server-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered

Hi,

As clarified in Supported Data Sources (SSAS - Multidimensional), the providers are listed. Using Azure AD Authentication in the connection is currently not supported in SSAS multidimensional cube, unfortunately, the mdx cube only supports Windows and SQL authentication.

Regards,
Lukas


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.