The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi Team,
we have a RLS table and added some uses into that, in the same table we have to use for workspace access,
Please find below example xls for easy understanding.
your help is required here.
Branch Code | Consultant | Service Workspace | Sales Workspace | SS Workspace |
250 | abc@mail.com | x | ||
275 | bca@mail.com | x | ||
286 | ccc@mail.com | x | ||
295 | eee@mail.com | x | ||
250 | xx@mail.com | x | ||
275 | xx@mail.com | x | ||
250 | yyy@mail.com | x | ||
275 | yyy@mail.com | x | ||
286 | yyy@mail.com | x | ||
295 | yyy@mail.com | x |
Regards,
Babu
RLS roles only control access to data in a data model. You cannot control workspace access using a table.
User | Count |
---|---|
2 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
7 | |
2 | |
2 | |
2 | |
2 |