Forum Discussion

nateharwood93's avatar
nateharwood93
Frequent Visitor
5 years ago
Solved

Failed to open the MSOLAP connection. - PowerBI Embedded

Hi, for background we are using RLS in powerbi embedded environment. It was working well, but now we've started to see 'Cannot Load Model' along with the below error details:   Underlying Error: Po...
Need Help
  • nateharwood93's avatar
    nateharwood93
    5 years ago

    Hi, the issue was related to RLS. There was a rogue space in the code, specifically where we defined the Role. Hopefully this is helpful to someone in the future.

Chith_123's avatar
Chith_123
Frequent Visitor
4 years ago

Hi Can you please elaborate a little bit about this rouge space issue, since I am having the same 

Failed to open the MSOLAP connection. - PowerBI Embedded 

Issue

debenaire's avatar
debenaire
Icon for Helper I rankHelper I
2 years ago

hi All thought I would contribute here. I had the same issue and it turned out to be linked to RLS and composite model. Effectively I belive I tried to use direct query on some tables to be used for RLS. To resolve the issue I removed the tables from my model, even though they were now in import mode and reimported them. This resolved the issue!