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: PowerBI service client received error HTTP response. HttpStatus: 503. PowerBIErrorCode: OpenConnectionError
OpenConnectionError: Failed to open the MSOLAP connection.
Correlation ID: 251a05ca-49c2-b078-0070-ca15d1207bba
Activity ID: 46818ebb-3748-453b-9042-d0aed7de2a4a
Request ID: c1b4567f-6a50-4b7d-a59d-cb48a66b67f1
Time: Fri Apr 16 2021 11:21:57 GMT+0100 (British Summer Time)
Service version: 13.0.15854.62
Client version: 2104.1.05665-train
Cluster URI: https://WABI-UK-SOUTH-B-PRIMARY-redirect.analysis.windows.net
Activity ID: 46818ebb-3748-453b-9042-d0aed7de2a4a
Request ID: c1b4567f-6a50-4b7d-a59d-cb48a66b67f1
Time: Fri Apr 16 2021 11:21:57 GMT+0100 (British Summer Time)
Service version: 13.0.15854.62
Client version: 2104.1.05665-train
Cluster URI: https://WABI-UK-SOUTH-B-PRIMARY-redirect.analysis.windows.net

 

The Gateway is working and data refresh is performing as expected. I can view the report fine in the powerbi service. Any help would be much appreciated, thank you. 

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.

8 Replies

  • nateharwood93's avatar
    nateharwood93
    Frequent Visitor
    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.

  • ibarrau's avatar
    ibarrau
    Icon for Super User rankSuper User
    5 years ago

    Hi. I don't know much about Embeding but I have software backgroud and I can tell you that 503 is "forbiden error". Check if the account or service principal used for embedding has the correct permission to handle the embedding. If this is a new development consider that the embed token can expire and it won't let you get in again, you need to retrive a renew or refresh token.

    Hope that helps for something.

  • nateharwood93's avatar
    nateharwood93
    Frequent Visitor
    5 years ago

    Thanks ibarrau, I really appreciate the response. The permissions are unchanged though since it was last working so I think there is another factor at play