Share via

How to deploy and refresh tabular model with AAD datasource

DAMIEN OCONNOR 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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator
    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

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.