Azure Analysis Services: Not able to connect to data source(SQL server) with Active directory(In Model.bim)

Question

In credential section of Model.bim we define the way we are going to authenticate the data source(here SQL server) , right now i'm using DB user, DB password with AuthenticationKind="UsernamePassword" and it is working fine and able to refresh models successfully. But now i want to authenticate the SQL server with Active directory instead of DB user and DB password. Can anyone help what should be AuthenticationKind for this? I tried using AuthenticationKind as "UsernamePassword" and "Windows" but it is not working.

Here is a sample dataSource part of Model.bim

"dataSources": [
{
"type": "structured",
"name": "SQL/sampsledb database windows net;sampsledb",
"connectionDetails": {
"protocol": "tds",
"address": {
"server": "sampsledb.database.windows.net",
"database": "sampsledb"
},
"authentication": null,
"query": null
},
"credential": {
"AuthenticationKind": "UsernamePassword",
"kind": "SQL",
"path": "sampsledb.database.windows.net;sampsledb",
"Username": "SampleUser",
"EncryptConnection": true
}
}
]

Answer 1

"AuthenticationKind": "UsernamePassword"

Try it with
"AuthenticationKind": "Windows"

Answer 2

@Pieboy Could you please try to force the connection to always use gateway on AAS by following the below steps -

1. Connect Management Server Name (which end with :rw) of AAS with SSMS.
2. Right click server name and choose Properties.
   Modify ASPaaS\AlwaysUserGateway to true
   
   3. Restart AAS server and try to process again.