Row Level Security

[gauravnarchal]

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

[email protected]  PowerBi login can only view the data Apple, Grapes, Pear, Mandarine, Watermelon, Coconut

[email protected]  PowerBi login can only view the data Tomatoes, Onion & ginger

[email protected]  PowerBi login can only view the data milk, bread, egg

Type

Tomatoes

Onion

Ginger

Apple

Grapes

Pear

Mandarine

Watermelon

Cocunut

Milk

Egg

Bread

[amitchandak · Accepted solution]

@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