Report security

[Anonymous]

Hi,

I have a report with 3 dashboards. From dashboard 1 we can drill through dashboard 2 or 3.

Dashboard 3 is consiting of a table with customers info, so some of our user should not see that dashboard.

Group A: can see first dashboard and drill through dashboard 2 or 3

Group B: can see first dashboard and drill through dashboard 2, but they are not authorised to see dashboard 3.

How can I apply the security roles to achieve this purpose?

[v-yalanwu-msft]

Hi， @Anonymous ；

Is your problem solved? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi, @Anonymous ;

You can use three dashboards as three pages, and set page-level RLS for each customer. For example, A can view pages 1, 2, and 3, and B can view pages 1, 2. You can refer to the following article about page level RLS.

https://radacad.com/page-level-security-workaround-in-power-bi

https://powerbiexperience.com/en/blog/definitive-guide-row-rls-column-and-page-security/

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.