The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
Solved! Go to 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
@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
User | Count |
---|---|
78 | |
73 | |
37 | |
30 | |
28 |
User | Count |
---|---|
107 | |
100 | |
55 | |
49 | |
45 |