Forum Discussion
Role Based Security stopping certain users from accessing drill through reports
I have a report with all the top level visualisations without any detailed data
I have drill throughs set up to detailed reports containing the underlying data
Ive looked at role based security but I cant see how you could stop certain users from drilling through to the underlying data
Does anyone have any ideas on this?
Thanks in advance
5 Replies
Hi DebbieE
create three tables and relationships as below
Manange rold as below, see details here
https://docs.microsoft.com/en-gb/power-bi/report-server/row-level-security-report-server
Add [details] in the table visual on page2, add [Category] from "top level" table in the Drillthrough filter field
add [category] from "top level" table in the table visual on Page1,
view as specific role, click ok, then drillthrough to page2
As tested, user "dale" can only see his own data.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Fantastic.
I will go through this this morning and let you know how it goes
Ive set up exactly as stated but its not worked.
Ive tried testing in service as ell as the desk top but you can see the detail of every row no matter who you log in as
Hi DebbieE
1. Make the relationship between "Toplevel" and "details" tables "single direction".
2.create RLS formula in the "User" table as my screenshot shown.
3. the "user" column in my test is the account which users use to log in the power bi instead of users' names.
for example, i user the following to sign in power bi.
4. if you publish the pbix report to an App workplace where members have edit permission, then RLS doesn't work.
please only give view permission to your users.
Best Regards
Maggie
