Forum Discussion
Dynamic RLS Not Populating Visuals with Data
Hello
We have implemented Dynamic RLS with the use of Azure Groups (AG). We defined a few roles and assigned individual AGs to their proper role so that no AG is assigned to more than one role.
We are currently experiencing an issue where users are not seeing any data. It does not prompt the user to request access as if they do not have the report shared with them, and it does not tell the user that data is restricted as if they are forbidden by security.
We are in a P1 environment with Large Dataset enabled (not across the workspace but only this dataset.) as the dataset is nearing 1.2GB in local (.pbix) size.
Please let me know if I can provide anymore details to help troubleshoot this issue.
15 Replies
Can you please share the DAX you are using for the role & a snippet of your model related to the security side?
The DAX is: [Email] = USERPRINCIPALNAME(). When testing roles locally, the security works as intended.
The model is as follows:
'SalesOrg1Security' *->-* 'SalesOrg1Dimension' 1->-* 'Facts'
'SalesOrg2Security' *->-* 'SalesOrg2Dimension' 1->-* 'Facts'
Could be that you have two separate tables filtering your fact table, but they may be acting as an AND and thus one canceling the other
Hi ajmonster ,
It's quite wierd. Since I can't get in touch with your file, I suggest you create a support ticket. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
