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

Pieboy 1 Reputation point

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": "",
"database": "sampsledb"
"authentication": null,
"query": null
"credential": {
"AuthenticationKind": "UsernamePassword",
"kind": "SQL",
"path": ";sampsledb",
"Username": "SampleUser",
"EncryptConnection": true

Azure Active Directory
Azure Active Directory
An Azure enterprise identity service that provides single sign-on and multi-factor authentication.
16,652 questions
Azure SQL Database
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
393 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,171 questions
4,388 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 34,286 Reputation points

    "AuthenticationKind": "UsernamePassword"

    Try it with
    "AuthenticationKind": "Windows"

  2. Saurabh Sharma 18,956 Reputation points Microsoft Employee

    @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
      1. Restart AAS server and try to process again.