Solved: Row Level Security

gauravnarchal · ‎04-07-2023

How can I add the RLS based on the PowerBi login IDs as

fruits@sample.com PowerBi login can only view the data Apple, Grapes, Pear, Mandarine, Watermelon, Coconut

veggie@sample.com PowerBi login can only view the data Tomatoes, Onion & ginger

Food@sample.com PowerBi login can only view the data milk, bread, egg

Type

Tomatoes

Onion

Ginger

Apple

Grapes

Pear

Mandarine

Watermelon

Cocunut

Milk

Egg

Bread

amitchandak · ‎04-07-2023

@gauravnarchal , You have create table with fruit name and email (assigned) and create a role in RLS

email = userprincipalname()

Power BI- Row Level Security: Handle ALL, UserPrincipalName: https://youtu.be/KVLEnIUo4pc

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

View solution in original post

amitchandak · ‎04-07-2023

@gauravnarchal , You have create table with fruit name and email (assigned) and create a role in RLS

email = userprincipalname()

Power BI- Row Level Security: Handle ALL, UserPrincipalName: https://youtu.be/KVLEnIUo4pc

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!