Connecting to Azure Analysis Services using python

Rajasekar Nonburaj 111

I am trying to query my powerbi metadata stored in Azure Analysis services through python. I have used Nuget package and loaded the dll "Microsoft.AnalysisServices.AdomdClient" to my root folder (RHEL Linux), when I tried to execute the below program it throws an error (screenshot attached below)

PRADEEPCHEEKATLA-MSFT 90,146 Reputation points Microsoft Employee

2021-02-16T08:52:24.023+00:00

Hello @Rajasekar Nonburaj ,

Welcome to the Microsoft Q&A platform.

Could you please share the script which you are trying to connect connecting to Azure Analysis Services using python and also please do share the complete stack trace of the error message which you are experiencing?

Meanwhile, I would suggest you to go through Connect to Azure Analysis Services Data in Python on Linux/UNIX.

Rajasekar Nonburaj 111

Hi,
Please find the code

from sys import path
path.append('/root/dll/Microsoft.AnalysisServices.AdomdClient.dll')
from pyadomd import Pyadomd
conn='Provider=MSOLAP;Data Source=powerbi://api.powerbi.com/v1.0/myorg/;Initial Catalog=testcube;User Id=testuser;Password=xxxxx ;'
query = "SELECT DIMENSION_CAPTION AS [DIMENSION] FROM $system.MDSchema_Dimensions"

with Pyadomd(conn) as conn:
    with conn.cursor().execute(query) as cur:
        print(cur.fetchall())

Lukas Yu -MSFT 5,821 Reputation points

2021-02-17T06:29:37.337+00:00

With the exception EntryPointNotFound, I suspect that if your library was correctly installed? Or if the AdomdClient path is correct?
Rajasekar Nonburaj 111 Reputation points

2021-02-17T06:35:59.223+00:00

yes, the library is installed correctly and the path also set correctly in the code.
PRADEEPCHEEKATLA-MSFT 90,146 Reputation points Microsoft Employee

2021-02-22T07:34:26.767+00:00

Hello @Rajasekar Nonburaj ,

Have you resolved the issue?

If not, could you please share the complete stack trace of the error message which you are experiencing?
Rajasekar Nonburaj 111 Reputation points

2021-02-22T08:37:36.99+00:00

No it is not working,
please find the complete error message

root@d1~]# python3 pyaas.py
Traceback (most recent call last):
File "pyaas.py", line 8, in <module>
with Pyadomd(conn) as conn:
File "/usr/local/lib/python3.8/site-packages/pyadomd/pyadomd.py", line 128, in init
self.conn.ConnectionString = conn_str
System.EntryPointNotFoundException: GetConsoleWindow assembly:<unknown assembly> type:<unknown type> member:(null)
at (wrapper managed-to-native) Microsoft.AnalysisServices.AdomdClient.Platform.Windows.Interop.NativeMethods.GetConsoleWindow()
at Microsoft.AnalysisServices.AdomdClient.Platform.Windows.Utils.WindowsRuntimeHelper.IsProcessWithUserInterface () [0x00018] in <7bc07fcc34d349be86dfb95e964041d1>:0
at Microsoft.AnalysisServices.AdomdClient.Platform.Configuration.ConfigurationHelper.CheckIfProcessWithUserInterface () [0x00009] in

Accepted answer

Rajasekar Nonburaj 111 Reputation points

2021-02-23T13:51:18.923+00:00

we were able to achieve solution for this issue, the same has been discussed in another thread.
https://learn.microsoft.com/en-us/answers/questions/233745/can-adomd-net-core-connect-to-an-ssas-endpoint-fro.html
Please sign in to rate this answer.

1 person found this answer helpful.
KranthiPakala-MSFT 46,502 Reputation points Microsoft Employee

2021-02-23T18:31:45.55+00:00

@Rajasekar Nonburaj - Thanks for sharing the solution here as it would be helpful for other community members reading this thread.
Sign in to comment

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

Share via

Connecting to Azure Analysis Services using python

0 additional answers

Your answer