Extract data directly from Azure Analysis Services using Azure Data Factory

Question

Hi

I am trying to get data from an OLAP cube in Azure Analysis Services (AAS)

source

https://asazure://...europe.asazure.windows.net/model

to Azure Data Factory (ADF) using query

EVALUATE SUMMARIZECOLUMNS (....)

Can you suggest any way how to do it?

(unfortunately using linked service(SQL) not a best solution for company )

is that possible to use REST API to get data from OLAP ? if yes could you please provide the example url
Many thanks

Answer 1

Hey,

unfortunately there is no direct connector to AAS as linked service within synapse/ADF but you can use a below workaround :

https://datasharkx.wordpress.com/2021/03/16/copy-data-from-ssas-aas-through-azure-data-factory/ As linked server is not preferred, then only below option would suffice:

But in case if there is an MFA issue, you would need to use MSFT fabric :

https://datasharkx.wordpress.com/2023/10/31/copy-data-from-azure-analysis-service-aas-through-microsoft-fabric/ As there is no rest api in analysis services to fetch data