Forum Discussion
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.
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.
