Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
The above image is my data model,from this i want develope row level security,scanario is
If a user is Admin then he can see all records,if he is not Admin he can see only his records, how we can implement dynamically.
we can do one way as per my knowledge that is we need to create 2 roles one for Admin and another for non Admin
after that Assigned users those roles then we can do.
Here my case is need to implement dynamically,we need to validate users admin or not based on that need to give .
Please help with suggestion.
Regards
Mallikarjun
Solved! Go to Solution.
If a user has multiple roles include Admin, as I understand, he/she should can see all records when he/she sign in to Power BI Service with his/her email, right?
Please try with following Table filter DAX expression
Best Regards,
Herbert
Hi Herbert,
Yes,same way i need to implement,
I have implemented same way which you given DAX,but for me i am getting Error,
In Filter first argument is table name,i given that one only.(GMP USER_APPLICATION_ROLE).
Can you please verify the same.
Hi Herbert,
Thanks for Your Wonderfull efforts !!
Finally i got the solution,You made me my day happy.
Feeling very Exicted ,Thanks you Very Much.
Regards
Mallikarjunarao
You can create a role with expression like below, and then publish to Service. Please refer to my recorded video to see the result.
Best Regards,
Herbert
Hi Herbert,
Thanks for Your Help on this,
Same way i have implemnted in my scanario,i shared to one of my collegue he is not seeing anything,
he has two roles,one is Admin and Another one is Operator.
can you please help me on this.
a user have multiple roles like Admin,Operator,supervisor if role name is Admin he can see,other then Admin he needs to see only his records
Regards
Mallikarjun
Here is my id i am not having Admin Role ,but i can see all the records.Can you please help me on this.
If a user has multiple roles include Admin, as I understand, he/she should can see all records when he/she sign in to Power BI Service with his/her email, right?
Please try with following Table filter DAX expression
Best Regards,
Herbert
Hi Herbert,
Thanks for Your Wonderfull efforts !!
Finally i got the solution,You made me my day happy.
Feeling very Exicted ,Thanks you Very Much.
Regards
Mallikarjunarao
Hi Herbert,
Yes,same way i need to implement,
I have implemented same way which you given DAX,but for me i am getting Error,
In Filter first argument is table name,i given that one only.(GMP USER_APPLICATION_ROLE).
Can you please verify the same.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.