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

[aignn]

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.

I have already tried to delete the PowerBI folder in Appdata, but it did not work : (

Who has encountered this error?

Help me please

Thank you advance!

[pratafran]

I had the same issue and I resolved by:

1. Clearing Cache from Power BI Report Server options

2. Removing credentials from SSAS connection

3. Closing and restarting the APP

[mwegener]

Hi @aignn 

did you see this?

https://community.powerbi.com/t5/Power-Query/unexpected-error-NamespacesMGR-threw-an-exception/m-p/1...

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

Please give Kudos for support.

[aignn]

Hi @mwegener Thank you for your reply. Yes. But i dont know what roles and perms needed...

[mwegener]

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]

@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]

I have no idea what it could be.

Could you share your MDX/DAX?

[aignn]

@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])

[mwegener]

Hi @aignn 

did you solve your problem?

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

Please give Kudos for support.

[mwegener]

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.

[mortegagt]

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