Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

How To Troubleshoot Unexpected Error Live Connect to SSAS OLAP Database

My team is having a hard time getting all of our cubes to be able to be used in Power BI.  Many work just fine but when we try to connect to others in the desktop we get "An error occurred while load...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Dale,

 

The credential works just fine in SSMS browsing the cube and via Excel. I am 99.9% sure this is not a privileges issue.  Also when you say to mask your private data what data are you referring to?  

 

Thanks.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

I think I might have potenially solved this but I would need confirmation from whomever knows what the code is doing when reading the metadata.

 

I ended up removing all of the Dimensions via Dimension Usage and starting adding them back in one by one.  Each time testing to see if Power BI could do a Live Connect on the cube. By the end when I got through all 100+ dimensions, I was still able to connect via Power BI.

 

I generated the xmla from the original cube not working and the rebuilt (sort of speak) one that was working. It turns out there are some differences like the UnknownMember property is missing on some of the original cube dimensions. The cube was originally built in 2005 or 2008 and migrated to 2012.  The UnknownMember property was introduced in SSAS 2012 from what I can tell.

 

It would be nice if someone could confirm my suspension on this.   

Thanks!

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi,

     

    Facing the same issue of 'Query System Error' when Power BI tries to connect SSAS MD model using Live connection. Frown traces are also the same. Applied SP 2 with CU10 for SQL Server 2014 (Latest updates) but still getting the same error. Any clue on probable solution on SSAS / Power BI end?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi 

     

    We are facing the same issue. Looks like Microsoft is not having any solution to this. We have enterprise version, CU8, SQL Server 2014, Power BI Pro and still gets the error. SSAS service restart used to be a work around till now, but now that is also not working out. Please suggest.

     

    Can anyone from Microsoft take a look specifically at the PBI and cube level and sugget? Its a show stopper for us as client is unable to use the report.