Forum Discussion

aignn's avatar
aignn
Helper II
6 years ago

AnalysisServices: The type initializer for 'Microsoft.AnalysisServices.AdomdClient.NamespacesMgr'

Hi!   I try get data from Analysis Services by query and i get this error: AnalysisServices: The type initializer for 'Microsoft.AnalysisServices.AdomdClient.NamespacesMgr' threw an exception.   ...
Need Help
aignn's avatar
aignn
Helper II
6 years ago
Hi mwegener Thank you for your reply. Yes. But i dont know what roles and perms needed...
  • mwegener's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    Hi aignn ,

     

    what are your actual perms on the AnalysisServices?
    An Excel connection to the cube works?

     

    If I answered your question, please mark my post as solution, this will also help others.

    Please give Kudos for support.

    • aignn's avatar
      aignn
      Helper II
      6 years ago

      mwegener 

      Im have admins perms.

      "Live connect" works fine.

      But when i try "import" with my query i get this error.

       

      At the same time I execute a query in SSMS and it works fine, gives results.

       

       

      • mwegener's avatar
        mwegener
        Most Valuable Professional
        6 years ago

        I have no idea what it could be.

        Could you share your MDX/DAX?