Share via

Extract data directly from Azure Analysis Services using Azure Data Factory

Mykola Avram 20 Reputation points
2023-11-13T13:50:42.03+00:00

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

Azure Analysis Services
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
0 comments
Answer accepted by question author
  1. Nandan Hegde 36,716 Reputation points MVP Volunteer Moderator
    2023-11-13T13:59:06.9266667+00:00

    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

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. 益宁 曹 0 Reputation points
    2025-09-03T02:32:53.7166667+00:00

    Hi ,

    I have the same issue where I need to obtain data from AAS, or is it possible for me to write a script in Databricks to retrieve the data? If so, could you please provide the relevant methods?

    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.