Forum Discussion
Row Level Security not working
PBIUSER3 Yes, I ended up using Dynamic RLS to fix the problem. Our PBI login matches ID's in the data, for example:
Login: [email protected]
Data: UserID- UserBob123; Customer-ABEX; Order#-7524
I then used a filter in the role like: UserPrincipalName()=Concatenate(UserID,"@microsoft.com")
Hope that helps!
He does not. He's not a member of the workspace and only accessing the report via the app.
HI jhartranft60,
Can you confirm your table has correspond records with that user?
>>He's not a member of the workspace and only accessing the report via the app.
Did you mean external guest from external tenant and use Azure B2B feature to get access permission?
Distribute Power BI content to external guest users with Azure AD B2B
Regards,
Xiaoxin Sheng
Hello,
Yes, I've used multiple test users at this point, each put into a different role. I'm not using Dynamic RLS, so the records shouldn't have to tie them directly, just to the rules of the roles I've put them in. As mentioned previously, I've tested the roles in both Desktop and Service and they work exactly as intended. I just can't seem to figure out why they don't work for any users that I assign to those roles.
>>He's not a member of the workspace and only accessing the report via the app.
>>Did you mean external guest from external tenant and use Azure B2B feature to get access permission?
>>No, this was in response to a previous question about the test user having edit permissions. My response is that they are not a member of the App Workspace and therefore that isn't a concern. They are a member of the organization given access to the app only.
Hi jhartranft60,
How did you assign roles? Assigned to email or office security group? If you mean security group, did this user joined in that group? Any specific permissions/rules enabled on this user?
In addition, you can also open a support ticket for better support from power bi team.Regards,
Xiaoxin Sheng