How to deploy and refresh tabular model with AAD datasource

Damien O'Connor 0 Reputation points Microsoft Employee
2023-06-05T09:04:34.8566667+00:00

I have a customer looking to deploy an Azure Analysis Services (AAS) tabular model using Azure DevOps. However the underlying database is a Synapse Lake Database which does not support SQL authentication. All the examples seem to be for sql auth.

They have been able to deploy it initially run run into issues with tokens expiring for the refresh.

How do we deploy and refresh tabular model where the datasource requires AAD auth?

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
443 questions
{count} votes

1 answer

Sort by: Most helpful
  1. BhargavaGunnam-MSFT 28,926 Reputation points Microsoft Employee
    2023-06-06T20:18:16.9333333+00:00

    Hello Damien O'Connor,

    Welcome to the MS Q&A platform.

    My understanding is Synapse Lake database supports SQL authentication(synapse lake databases are on serverless SQL endpoint).

    User's image

    User's image

    However, you can use logic apps and rest API to deploy and refresh a tabular model where the data source requires AAD auth.

    Please see this video tutorial and the below Microsoft documentation.

    https://learn.microsoft.com/en-us/azure/analysis-services/analysis-services-refresh-logic-app

    I hope this helps.

    0 comments No comments