Forum Discussion
AnalysisServices: The type initializer for 'Microsoft.AnalysisServices.AdomdClient.NamespacesMgr'
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
