Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Report security

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?

2 Replies

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support

    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.

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support

    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.