Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I currently have a role for a table where I have cost centers id's and e-mails. In the role I am saying that only people who logs into Power BI with an e-mail that is in the table UPN, E-mail or E-mail 2 can see their cost centers. The table with the e-mails has a relation with the company dimension.
I expect that someone who has not an e-mail adres in the table sees nothing. This happens in the Power BI desktop when I test the role and I fill in an e-mail that is not in the table. But in the Power BI Service when I add an user to the role that is not in the table he sees all data and not nothing. Does anybody know why this is happening?
The role for table UPN per cost center:
[UPN] = userprincipalname()
|| [E-mail] = userprincipalname()
|| [E-mail_2] = userprincipalname()
Solved! Go to Solution.
Hi @rla,
Did you check if the user who has entry in the table are able to see only the restricted records?
For Security to work for a user in Power BI Service, the User should not be an Admin of the workspace and he also should not have edit permission to the workspace
If either the user is an Admin or he has edit permission to the workspace, the RLS won't work for that user
PFB link for reference
Hi @rla,
Did you check if the user who has entry in the table are able to see only the restricted records?
For Security to work for a user in Power BI Service, the User should not be an Admin of the workspace and he also should not have edit permission to the workspace
If either the user is an Admin or he has edit permission to the workspace, the RLS won't work for that user
PFB link for reference
Did you check the report in others workspace?
If you were an owner of the report you will have full access on the dataset. It might be the reason. Create an app workspace and add the people and give only read access to them. Finally, ask them to check the report. it will work.
User | Count |
---|---|
125 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |