Forum Discussion
AnalysisServices: The type initializer for 'Microsoft.AnalysisServices.AdomdClient.NamespacesMgr'
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.
I have no idea what it could be.
Could you share your MDX/DAX?
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])Does not look like the problem.
Which Power BI Desktop version do you use?
Which AnalysisServices version number do you use?
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
Good morning, I have the same error message, I will thank very much for the help you can give me.
The version I have of BI Desktop is Version: 2.81.5831.821 64-bit (May 2020)
The version of AnalysisServices I use is 13.0.4001.0 created in SQL Server Managment Studio 2008 v18.5
In excel (local on my pc) if I allow the connection
In online PBI with the connection by means of a link box, it establishes the communication.
But by not getting it done on desktop I can't generate the report to publish it.
Best regards
