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?

      • aignn's avatar
        aignn
        Helper II
        6 years ago

        mwegener 

        No problem:

         

        SELECT {[Measures].[Completed]} ON 0,
    NON EMPTY CrossJoin(
	    Hierarchize([Work Item Tree].[Work Item Tree Hierarchy].Members),
        [Work Item].[System_Id].[System_Id],
        [Work Item].[System_Title].[System_Title],       
        [Work Item].[System_AssignedTo].[System_AssignedTo],
        [Work Item].[System_State].[System_State]
    ) ON 1
 FROM [Teams]
WHERE ([Date].[Year - Month - Date Hierarchy].[Month].&[2019-11-01T00:00:00])