How to get list of all the tabular models in a Analysis server using databricks ?

[UmaMahesh1]

Hello community,

I want to fetch the list of all the tabular models (if possible details about those models too) which are there in a SQL Analysis server using databricks.

Can anyone help me out ?

Use case: I want to process clear a large number of models with the exception of some specific models. In a server, I might have 50 models or so and hence manual processing is not ideal. So I want to fetch out all the cube names and I will manually provide the exceptions list (cubes which should not be cleared) and then through logic apps and ADF will process.

If anyone has any other alternative approach, please answer the same.

Thanks..

[Debayan]

Hi, are you talking about the Azure Analysis server?

please let us know if this helps: https://stackoverflow.com/questions/64431691/load-data-from-databricks-to-azure-analysis-services-aa...

[omfspartan]

Did you try Azure Analysis Services Rest API?