This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more
I need some help:
1. I created the roles in the destop and tested them under " view as roles" and everything works.
2. I published to the Service and went to "security" under "Data Sets" and added names to each role
3. I Also tested the roles in the service and everything works.
4. When a specfic person logs in after I assigned them to a specific role, they unfortantely still see everything instead of the specific region.
This is frustrating and I do not know what to do, can you please help?
I need some help
1. I have set up roles in desktop and tested them, everything works.
2. I published to service and added names to "security" under "data sets".
3. I test the roles in service and works just fine.
4. When I add person to specifc role, they still see all data instead of the data in that specific role I created.
There are a few steps you need to go through with RLS. It is best to use and puplish an app.
Select ..., then edit workspace
Go to Dataset, then ..., then security. Confirm or Add the user to the Row-Level Security
Update app, then Access and add user … publish
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 14 | |
| 11 | |
| 9 | |
| 8 | |
| 6 |