Connect to Azure SQL DB from Analysis services through active directory or Managed Identity ?

AZ_Asma Bano 1

How to Connect to Azure SQL DB from Analysis services through azure active directory or Managed Identity ?
While giving connection string instead of username and pwd, I want to give AAD or MI.
Any suggestions or step-by-step procedure ?

AZ_Asma Bano 1 Reputation point

2021-10-19T07:06:57.293+00:00

This is my connection string code in visual studio :
"dataSources": [
{
"connectionString": "Provider=SQLNCLI11;Persist Security Info=true; User ID=user_id ;Data Source=server_name ; Initial File Name=;Server SPN=;Initial Catalog=DB_name",
"impersonationMode": "impersonateServiceAccount",
"annotations": [
{
"name": "ConnectionEditUISource",
"value": "SqlServer"
}
]