Forum Discussion
Dynamic RLS, controlled from SharePoint list, with ALL option
Hi Anonymous
I think now your sharepoint list may be like my sample as below.
Due to you need to relate Role ID with Team ID for dynamic RLS .
Blank in Role ID will return to blank, so it is incorret.
If you only want to add master under your exist users in Sharepoint List.
You can try to update your Sharepoint List as below.
View as "[email protected]", I can only see Team A.
View as "[email protected]", I can see all Teams.
My Dax is same as yours, it works well.
Or you can try to build Dynamic Row Level Security with Organizational Hierarchy in Power BI.
You can refer to this blog for more details : Dynamic Row Level Security with Organizational Hierarchy.
Video: Row Level Security Organizational Hierarchy
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sounds like you should have two Roles in Power BI, and two AD Security Groups. One Role/AD Group is for those people that should be governed by RLS, and one Role/AD Group for Master. In Power BI, simply create the Role, but don't but any Security filter statements on it.
Once it is deployed, on the Dataset Permissions tab, add the AD Group for Master to the Master Role.
Now, anybody that gets added to the Master AD group will have unfiltered access to Power BI data.