Add Row Level Security to your solution with the Permissions Table to filter down the access to the data users have access to.
1. Open the PBIX file.
2. Go to Transform and make sure the tables DimOrgStructure and DimOrgStructurePermissions are added.
3. Back in Power BI Desktop, open the Modeling tab and click on Manage Roles.
4. Click on Create and change the name of New Role to Admin.
5. Click on Create once more and change the name of New Role to Users.
6. In the Users Role, add the following Dax filter to the DimOrgStructure Permissions Table.
or([DomainUserName]=username(),[UserPrincipalName]=userprincipalname())
7. Click Save when done
8. Create a relationship from the Permissions table to the DimOrgStructure table.
Use the columns below to create the relationship:
'DimOrgStructurePermissions'[HierarchyId]
'DimOrgStructure'[Site_Code]
9. Select Both in the Cross filter direction and check the box for Apply security filter in both directions.
10. Click OK when done
11. Once the report is published, go to the Workspace to find the dataset. Display its options and click on Security
12. Select the Users role, then find the ATS Badged Employees group in the Enter email addresses box and click Add.
13. Click Save when done.
0 Comments
Add your comment