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

Power BI to Analysis Services Connection Failed

Hi, there

 

I am having issues connecting to my SQL Server Analysis Services database:

Iternal Error: mddiscovermd.cpp, line 218, function "MDDiscoverMD:Smiley FrustratederializeRowToMXL"

 

How to solve the issue?

 

Thanks a lot!

7 REPLIES 7
Moderator mllopis
Moderator

Re: Power BI to Analysis Services Connection Failed

Hi Olga,

 

Could you confirm which option did you pick in the Analysis Services connector dialog? Was it Explore or Import?

 

Thanks,
M.

 

 

olgaakasatkina Frequent Visitor
Frequent Visitor

Re: Power BI to Analysis Services Connection Failed

Hi M,

 

Actually, I didn't use the Analysis Services connector Smiley Happy

I read later that I should use AS connector in order to connect to SQL Server Analysis Services database.

 

Is there any step-by-step guide "how to connect to SSAS Database" for dummies Smiley Happy?

 

Thanks in advance!

NH Member
Member

Re: Power BI to Analysis Services Connection Failed

I've encountered the same issue. Anyone can help to advise how to resolve this? Thanks.

bapt69 Member
Member

Re: Power BI to Analysis Services Connection Failed

Sorry, I didn't install it. Our IT did it. I only know you have to install the gateway on the SSAS, not on your computer.

Be carefull, you often need to update it.

info_alchemist Frequent Visitor
Frequent Visitor

Re: Power BI to Analysis Services Connection Failed

Did someone know how to fix this error?
dataGeek New Member
New Member

Re: Power BI to Analysis Services Connection Failed

Seems like you don't have proper persmissions to read content on the db. 

Highlighted
birgirs Frequent Visitor
Frequent Visitor

Re: Power BI to Analysis Services Connection Failed

Hi @olgaakasatkina

 

did you get a solution for this issue?

-B