Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Since i dont have emloyee email data how can I do row level security based on the employee id noton the emloyee email address
any direction for me ?
@prajaktakeni11 , So, either create as many roles as there are employees[Advised not to] or add another column to the employee ID table that holds employee email. Otherwise there is no way of connecting employees to the role.
@prajaktakeni11 , Assignment to the role is done with the help of user email and cannot be done by employee ID. In a way access is shared to those emailID for a particular role. For example, a role 'Viewer' is assigned to some people, this can only be acessed by people with the emailID of those users.
Hi @ChiragGarg2512 ,
Thank you for you reply... but i dont have email address in my table so can you please let me know workaround to this ?
@prajaktakeni11 when you ask for rls for do you mean to apply rls on employee ID or to give access to a role using employeeID?
@prajaktakeni11 So if a role is made, the person for the role can see data matching only his employee ID, Correct?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
66 | |
62 | |
62 |
User | Count |
---|---|
199 | |
120 | |
110 | |
79 | |
69 |