how to connect to Azure Analysis Services using python?

Braithwaite, Catherine 1 Reputation point
2022-02-04T16:32:18.32+00:00

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?

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
439 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee
    2022-02-07T22:42:42.327+00:00

    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:

    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:

    172082-image.png

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

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

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png 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