Role Based Security stopping certain users from accessing drill through reports

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.