Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
But the data-model I am working on is different & we have to change RLS methodology in order to meet the data-model structure , save time & offers as-well.
data-model structure NOW is having LAN USER ID fo each records
so have to create only role by ENDUSERFUNCTION..
Kindly advice
How we can make security roles on specific chart only?
Hi @Anonymous
It seems you need to use RLS to restrict the data model.For further,please refer to below posts.
https://radacad.com/dynamic-row-level-security-with-power-bi-made-simple
https://radacad.com/dynamic-row-level-security-with-manager-level-access-in-power-bi
For 3rd party Links:
Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights
Regards,
I tried this also but not working !!
Really appreciated your cooperation & support
I complete 50% of my issue
(which are each user can check his own data)
a
another 50%
(which are each Manager can check his employees ) !!
when I view role it show no result
because no employee manager for him self !!
>>can`t do it by DAX
because seems like it doesn`t acceppt or "||" intead of "&&"
like query
Kindly advice
User | Count |
---|---|
101 | |
90 | |
79 | |
70 | |
70 |
User | Count |
---|---|
112 | |
96 | |
96 | |
75 | |
72 |