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 securi...
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