how to connect to Azure Analysis Services using python?

Question

I previously used pyadomd but Microsoft.AnalysisServices.AdomdClient.dll was deleted in the latest update.
Due to workplace restrictions I cannot redownload the package this was originally found in.
Is there another way to connect to a database in a shared drive?

Answer 1

Hello @Braithwaite, Catherine ,

Thanks for the question and using MS Q&A platform.

As I understand the ask is that you are not able to see Microsoft.AnalysisServices.AdomdClient.dll package in latest version of pyadomd. Please correct if I'm not accurate.

While investigating on this issue, looks like Microsoft.AnalysisServices.AdomdClient.dll is still available in latest version of pyadomd. Please refer to this docs:

• pyadomd 0.1.1 - Latest Version
• https://github.com/S-C-O-U-T/Pyadomd/blob/master/pyadomd/pyadomd.py

Have received below error and came to a conclusion that package has been removed? If so, we recommend checking if you have added the folder with the Microsoft.AnalysisServices.AdomdClient.dll to your path, before you import the pyadomd package.

Error Message: System.IO.FileNotFoundException: Unable to find assembly 'Microsoft.AnalysisServices.AdomdClient'. at Python.Runtime.CLRModule.AddReference(String name)

Please to below FAQ from this doc:

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. 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
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators