I am reaching out here for guidance and assistance with a unique challenge I am facing in accessing Azure Analysis Model data. Despite the absence of a dedicated API in the official Azure documentation, I am seeking a way to extract this data and seamlessly transmit it to a downstream application. Issue Explanation: My goal is to access data from an Azure Analysis Model, even though there is no direct API available for this purpose according to the official Azure documentation. Instead, I am exploring alternative methods to retrieve this data. Kindly need assistance here.

@Anil Thota - Thanks for the question and using MS Q&A platform, I understand that you are looking for a way to extract data from an Azure Analysis Model, even though there is no direct API available for this purpose according to the official Azure documentation. While there is no dedicated API for this, there are a few alternative methods that you can explore to retrieve this data. One option is to use the XMLA endpoint to connect to the Analysis Services server and execute queries against the model. You can use any XMLA client to connect to the endpoint, such as SQL Server Management Studio (SSMS) or Excel. Once connected, you can execute queries against the model and retrieve the data. Another option is to use the On-premises data gateway to connect to the Analysis Services server and retrieve the data**.** The gateway allows you to securely connect to on-premises data sources, including Analysis Services, and expose them as cloud-based data sources. You can then use Power BI or other downstream applications to connect to the gateway and retrieve the data. Hope this helps. Do let us know if you any further queries. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Cannot find API's to extract Azure Analysis Model Data

Accepted answer

PRADEEPCHEEKATLA-MSFT 90,221 Reputation points Microsoft Employee

2023-08-31T07:46:50.35+00:00

@Anil Thota - Thanks for the question and using MS Q&A platform,

I understand that you are looking for a way to extract data from an Azure Analysis Model, even though there is no direct API available for this purpose according to the official Azure documentation. While there is no dedicated API for this, there are a few alternative methods that you can explore to retrieve this data.

One option is to use the XMLA endpoint to connect to the Analysis Services server and execute queries against the model. You can use any XMLA client to connect to the endpoint, such as SQL Server Management Studio (SSMS) or Excel. Once connected, you can execute queries against the model and retrieve the data.

Another option is to use the On-premises data gateway to connect to the Analysis Services server and retrieve the data**.** The gateway allows you to securely connect to on-premises data sources, including Analysis Services, and expose them as cloud-based data sources. You can then use Power BI or other downstream applications to connect to the gateway and retrieve the data.

Hope this helps. Do let us know if you any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Please sign in to rate this answer.
Anil Thota 20 Reputation points

2023-08-31T19:40:27.74+00:00

Hi Pradeep,

Thank you for your response, I already tried the way the you mentioned but didn't work. I would like to understand how the process of using on-premise does works. Here I want to perform integration between Azure Analysis Services and my downstream application but my integration platform need some API to extract the model data but in Azure API documentation I could not find any.

Thanks,

Anil

Anil Thota 20 Reputation points

2023-08-31T19:44:59.12+00:00

What are the other alternate ways to get the data from Azure Analysis Model apart from Excel and PowerBI

PRADEEPCHEEKATLA-MSFT 90,221 Reputation points Microsoft Employee

2023-09-04T07:43:26.78+00:00

@Anil Thota - I'm sorry to hear that the previous methods did not work for you. Let me explain how the On-premises data gateway works and suggest some other alternative methods to retrieve data from Azure Analysis Model.

The On-premises data gateway is a client agent that you install on a local computer or server. It allows you to securely connect to on-premises data sources, including Analysis Services, and expose them as cloud-based data sources. Once you have installed the gateway and configured it to connect to your Analysis Services server, you can use Power BI or other downstream applications to connect to the gateway and retrieve the data.

If you are looking for other alternative methods to retrieve data from Azure Analysis Model, you can consider using the following:

Tabular Object Model (TOM): The TOM is a .NET library that allows you to programmatically interact with Analysis Services tabular models. You can use the TOM to retrieve data from the model and perform other operations, such as creating and modifying objects in the model.

Analysis Management Objects (AMO): The AMO is a .NET library that allows you to manage Analysis Services objects, such as databases, cubes, and dimensions. You can use the AMO to retrieve data from the model and perform other operations, such as creating and modifying objects in the model.

XMLA Scripting: XMLA is a protocol used to communicate with Analysis Services servers. You can use XMLA scripting to execute queries against the model and retrieve the data. You can use any XMLA client to connect to the endpoint, such as SQL Server Management Studio (SSMS) or Excel.

I hope this helps! Let me know if you have any further questions or if there is anything else I can assist you with.

Anil Thota 20 Reputation points

2023-09-05T15:16:40.26+00:00

Thank you for the detailed information. I am interested in getting a walkthrough on how to use Analysis Management Objects (AMO) for retrieving data from Azure Analysis Model. Do you have any experience with this method and can you provide a step-by-step guide or walkthrough, it would be greatly appreciated. Your assistance would be immensely helpful.

Thank you,
Anil
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Cannot find API's to extract Azure Analysis Model Data

0 additional answers

Your answer