Forum Discussion
Using Roles to filter data
Okay so I have managed to add Users now to my Row Level Security.
For all those who are struggling with this bit you need to navigate to the PowerBI service and do it there. You can't do it in the PowerBI Desktop app.
Click on the Workspace where your report is in and you should have a short menu 'Dashboards, Reports, Workbooks, Datasets.
Click on Datasets and that is where the Elipses is i.e. the three dots '...' . You click on the three dots and select Security and everything else then makes sense.
So having added myself in and selected 'Test as Role' I can see that it works brilliantly. However, when I navigate to the report from Workspace I still see all Records in the table. Why?
(Just to make it clear, I've opening up PowerBI service. Selecting My Workspace --> Clicking on Reports -->Selecting my Report and...all records rather than just mine. If I select My Workspace --> Datasets --> ... --> Security --> RLSName ... --> Test as role The report shows perfectly!)
Hi Clandestine,
you have to add users to the role in powerbi.com. Locate your dataset in the left menu, right click on it and choose Security. Add yourself/other users/usergroups that will be using the report, and RLS will work
cheers,
Sturla
Thanks Sturla for the reply. I'm going to have to look at this tomorrow...it;s so frustrating, I'm so close!
My left menu only shows three icons - Report, Data and Relationships....I've tried right clicking on all three and looking at the 'Recent Sources' under the Home menu but to no avail.
I have just noticed that there is a update so tomorrow I will update my desktop version and hopefully it will all become clear!
I do appreciate the reply though.
Okay so I have managed to add Users now to my Row Level Security.
For all those who are struggling with this bit you need to navigate to the PowerBI service and do it there. You can't do it in the PowerBI Desktop app.
Click on the Workspace where your report is in and you should have a short menu 'Dashboards, Reports, Workbooks, Datasets.
Click on Datasets and that is where the Elipses is i.e. the three dots '...' . You click on the three dots and select Security and everything else then makes sense.
So having added myself in and selected 'Test as Role' I can see that it works brilliantly. However, when I navigate to the report from Workspace I still see all Records in the table. Why?
(Just to make it clear, I've opening up PowerBI service. Selecting My Workspace --> Clicking on Reports -->Selecting my Report and...all records rather than just mine. If I select My Workspace --> Datasets --> ... --> Security --> RLSName ... --> Test as role The report shows perfectly!)
Warning: Row Level Security does not work when viewing the report in the Workspace. Anyone that has permission to the Workspace will be able to see all the data. Row Level Security will only restrict data once the report is deployed.
