Cannot find API's to extract Azure Analysis Model Data

Question

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.

Answer 1

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