cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
birgirs Frequent Visitor
Frequent Visitor

Error when connecting to analysis service

im trying to connect to a multidimensional cube and i get this error:

 

AnalysisServices: Internal error: An unexpected error occurred (file 'mddiscovermd.cpp', line 230, function ' MDDiscoverMD:: SerializeRowToXML').

 

anyone have a solution for this?

-b

6 REPLIES 6
birgirs Frequent Visitor
Frequent Visitor

Re: Error when connecting to analysis service

v-ljerr-msft Super Contributor
Super Contributor

Re: Error when connecting to analysis service

Hi @birgirs,

 

To narrow down this issue, could you try using SSMS which is on the same computer that you have Power BI Desktop installed to connect to the multidimensional cube to see if the connection works? Smiley Happy

 

Regards

birgirs Frequent Visitor
Frequent Visitor

Re: Error when connecting to analysis service

Hi @v-ljerr-msft

and thanks for your reply 

i have tested connecting to the cube with SSMS and it works fine

and also Excel with no problem

-b

birgirs Frequent Visitor
Frequent Visitor

Re: Error when connecting to analysis service

@v-ljerr-msft

sorry to tag you again Smiley Happy

do you have any ide to solve this?

-b

 

v-ljerr-msft Super Contributor
Super Contributor

Re: Error when connecting to analysis service

Hi @birgirs,

 

Sorry for the delay response!


i have tested connecting to the cube with SSMS and it works fine

and also Excel with no problem


So the issue may lie on Power BI Desktop side. However, I'm not able to reproduce this issue on my environment with the latest version(2.47.4766.801) of Power BI Desktop.

 

In this scenario, I would suggest you create a support ticket on Power BI Support page for better assistance on it. Smiley Happy

 

Regards

Highlighted
birgirs Frequent Visitor
Frequent Visitor

Re: Error when connecting to analysis service

i also have that version of Powe bi and i can connect to tabular cubes with power bi and that works fine

but i will create a support ticket 

 

thanks for your help @v-ljerr-msft