Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

0
Katie-Robinson

Couldn't load the data for this visual

Submitted by on ‎04-20-2022 03:24 AM

Hello,

 

I've received a 'Couldn't load the data for this visual' based on 'The user belongs to multiple roles 'Lambeth, Southwark' that have security filters, which isn't supported when one of the roles has filters affecting table 'Fact Tonnage Allocations' with SecurityFilteringBehavior=Both relationships.' 

 

Lambeth no longer exists as a role in PowerBI, which is correct but it means I can't go into any Lambeth accounts to update my security filtering. I just need access to my Southwark role now so if there's anyway to delete or update that, that would be great.

 

Details:

Activity ID: 20223bc5-b5d6-4de0-90b9-c12132dace90

Request ID: 32d8ef58-e977-4524-87c6-01fe7ed0e096

Correlation ID: e964dd9f-7d95-568c-f34a-43acd1c31242

Time: Wed Apr 20 2022 10:55:14 GMT+0100 (British Summer Time)

Service version: 13.0.18082.40

Client version: 2204.2.10821-train

Cluster URI: https://wabi-north-europe-g-primary-redirect.analysis.windows.net/

Status: Delivered

You will get an error message if you belong to multiple RLS roles and at least one of the roles relies on a limited relationship.

 

Adopt one of the following workarounds to avoid this error:

  • If feasible, don't put any user into multiple RLS roles. In the scenario above, we can create another RLS role, e.g. RLS_Product_Customer, which combines the RLS filters set in both RLS_Product and RLS_Customer. Next, we can assign User A to just RLS_Product_Customer, and remove the user from both RLS_Product and RLS_Customer.
  • Define RLS roles only on one source group. If it's necessary for a user to belong to multiple RLS roles, make sure all RLS filters set in the roles are defined on tables from a single source group. In the scenario above, if we could define RLS_Customer on the source group that contains Sales and Product, we could avoid the error.

 

See: Issue: Multiple roles and limited relationships 

 

Best Regards,
Community Support Team _ Yingjie Li

See more ideas labeled with:
1 Comment (1 New)
Comments
v-yingjl
Community Support
Community Support
‎04-20-2022 06:43 PM
Status changed to: Delivered

You will get an error message if you belong to multiple RLS roles and at least one of the roles relies on a limited relationship.

 

Adopt one of the following workarounds to avoid this error:

  • If feasible, don't put any user into multiple RLS roles. In the scenario above, we can create another RLS role, e.g. RLS_Product_Customer, which combines the RLS filters set in both RLS_Product and RLS_Customer. Next, we can assign User A to just RLS_Product_Customer, and remove the user from both RLS_Product and RLS_Customer.
  • Define RLS roles only on one source group. If it's necessary for a user to belong to multiple RLS roles, make sure all RLS filters set in the roles are defined on tables from a single source group. In the scenario above, if we could define RLS_Customer on the source group that contains Sales and Product, we could avoid the error.

 

See: Issue: Multiple roles and limited relationships 

 

Best Regards,
Community Support Team _ Yingjie Li

Idea Statuses