Forum Discussion

gauravnarchal's avatar
gauravnarchal
Post Prodigy
3 years ago
Solved

Row Level Security

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...
  • amitchandak's avatar
    3 years ago

    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