Error when connecting to analysis service

[birgirs]

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

[v-ljerr-msft]

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? 

Regards

[birgirs]

@v-ljerr-msft

sorry to tag you again 🙂

do you have any ide to solve this?

-b

[birgirs]

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

[v-ljerr-msft]

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. 

Regards

[birgirs]

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

[birgirs]

found the same question here 

https://community.powerbi.com/t5/Desktop/Power-BI-to-Analysis-Services-Connection-Failed/m-p/8412/hi...

but no solution