How to deploy and refresh tabular model with AAD datasource

Question

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?

Answer 1

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).

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.