Data/row level security on bookmarks

[refint650]

Hello Team

In dashboard we  have 3 bookmarks  and each bookmark has different pie charts ,based on bookmark selection pie chart will show in report.  we want implement data/row level security  based user login into power bi   to show bokmarks  which usergroup he belongs to.  two columns from sap security table( userid, email).

I'm creating three user groups tables  in power bi  M query (user 1 table, user2 table user3 table.) is that posssible to render based on user login can we render bookmark page.?

bookmark 1  - User ID 1

bookmark 2 - User ID 2

Bookmark 3 - UsersID 3  

Thanks

Vs

[Anonymous]

Hi @refint650 ,

Please take a look at the dynamic RLS in Power BI.

https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls#using-the-username-or-userpri... 

https://medium.com/analytics-vidhya/power-bi-row-level-security-and-dynamic-rls-1ee7faaa703e 

Best Regards,

Jay