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

SuperCoolGuy's avatar
SuperCoolGuy
Frequent Visitor
2 years ago

Just thought I would post how I resolved this issue as I didn't find it anywhere. (Potentially similar solution to the "rogue blank space")

I inhertied our reporting architecture and we use PBI Embedded service. One of the requirements is that we must have a role created on the report (RLS), however, the role name must be a specific word. In my case, I was adding the role name as "Subscription" whereas it MUST be "Subscriber". This wasn't documented anywhere so I only figured it out by reviewing other reports.