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
}
}
]