Forum Discussion

Copper Contributor

Feb 23, 2025

Unable to process AAS model connecting to Azure SQL with Service Account

Hello I have built a demo SSAS model that I am hosting on an Azure Analysis Services Server. The model connects to an Azure SQL database in my tenant (the Database is the default AdventureWorks prov...

MVP

Feb 26, 2025

How about this:

{
  "createOrReplace": {
    "object": {
      "database": "$(AAS_DATABASE)",
      "dataSource": "$(AZSQLDataSourceName)"
    },
    "dataSource": {
      "type": "structured",
      "name": "$(AZSQLDataSourceName)",
      "connectionDetails": {
        "protocol": "tds",
        "address": {
          "server": "$(AZSQLServer)"
        },
        "initialCatalog": "$(AZSQLDatabase)"
      },
      "credential": {
        "AuthenticationKind": "ServicePrincipal",
        "username": "$(AZSQL_CLIENT_ID)",
        "password": "$(AZSQL_CLIENT_SECRET)",
        "tenantId": "$(AZSQL_TENANT_ID)"
      }
    }
  }
}