My requirement is to connect to Azure analysis services and retrieve tabular model's metadata. I am able to connect to this service from SSMS (Sql server management studio) and execute DMV queries. I would like to do this programmatically. What options I have to execute these queries from my application? example a java client using ODBC/JDBC connectivity or is it exposed through XMLA ?

Hi @Sibi Narayanaswamy , Thanks for your patience. I got update from product team that AAS doesn’t support Java natively and can use .NET Core to wrap around it, or can use an custom JSON proxy wrapper that can be integrated with Java. Sample code for the wrapper is found here . The sample provides a REST-like interface to an XMLA endpoint, passing through the client’s authentication using either a Bearer token, UPN/Password pair, or a Service Principal and Client Secret, and returning data as JSON. Main changes: 1) Support for Power BI Premium XML\A Endpoints 2) Migrated the project to .NET 5, enabling cross-platform deployment 3) Added a SwaggerUI and additional REST endpoints to list model tables and dump a single table 4) Added a README with instructions on getting started Please let us know for further queries and we will be glad to assist. -- Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how . Want a reminder to come back and check responses? Here is how to subscribe to a notification .

How to connect to Azure Analysis Services from java or other languages and execute DMV queries without using SSMS or MSMDPUMP.dll

Accepted answer

HarithaMaddi-MSFT 10,136 Reputation points

2021-01-20T07:04:51.493+00:00
Hi @Sibi Narayanaswamy ,

Thanks for your patience. I got update from product team that AAS doesn’t support Java natively and can use .NET Core to wrap around it, or can use an custom JSON proxy wrapper that can be integrated with Java. Sample code for the wrapper is found here.

The sample provides a REST-like interface to an XMLA endpoint, passing through the client’s authentication using either a Bearer token, UPN/Password pair, or a Service Principal and Client Secret, and returning data as JSON.

Main changes:

1) Support for Power BI Premium XML\A Endpoints
2) Migrated the project to .NET 5, enabling cross-platform deployment
3) Added a SwaggerUI and additional REST endpoints to list model tables and dump a single table
4) Added a README with instructions on getting started

Please let us know for further queries and we will be glad to assist.

--

Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.

Want a reminder to come back and check responses? Here is how to subscribe to a notification.
Please sign in to rate this answer.

1 person found this answer helpful.
HarithaMaddi-MSFT 10,136 Reputation points

2021-01-21T11:35:04.77+00:00

Hi @Sibi Narayanaswamy ,

We have not received a response from you. Please suggest if above suggested approach is helpful. Otherwise, let us know and we will continue to engage with you on the query.

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members.

Sibi Narayanaswamy 41 Reputation points

2021-01-22T03:03:06.17+00:00

Hi,

I am working on setting up the environment and testing it out. Will come back with any queries in a couple of days.

Since its not natively supported by java, Does Python + ADO.NET libraries will help to connect to this Azure Analytic Services endpoint to execute the DMC queries. Could you suggest any libraries for Python? Thanks in advance.

HarithaMaddi-MSFT 10,136 Reputation points

2021-01-25T11:16:14.31+00:00

Hi @Sibi Narayanaswamy ,

As per my understanding and interaction with product team, there is no other approach currently available other than the one specified. Please let us know if you got a chance to test the same.

Thanks for your understanding!

HarithaMaddi-MSFT 10,136 Reputation points

2021-01-27T07:13:01.92+00:00

Hi @Sibi Narayanaswamy ,

We have not received a response from you. Please suggest if above suggested approach is helpful. Otherwise, let us know and we will continue to engage with you on the query.

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members.

HarithaMaddi-MSFT 10,136 Reputation points

2021-01-28T05:42:46.117+00:00

Hi @Sibi Narayanaswamy ,

We still have not heard back from you. Following up to check if above suggested approach is helpful. Otherwise, let us know and we will continue to engage with you on the query.

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members.
Sign in to comment

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

Share via

How to connect to Azure Analysis Services from java or other languages and execute DMV queries without using SSMS or MSMDPUMP.dll

0 additional answers

Your answer