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.
My scenario needs to implement organizational hierarchy level access in premium capacity.
I have Test database in Vertica DB where 9 levels of managers hierarchy table been pulled into a direct query.
I need globally all sales rep to need to see their country data except managers need to see all.
Country[CountryKey] = LOOKUPVALUE( its not working in DQ)
'Security'[CountryKey],
'Security'[EmailAddress],USERPRINCIPALNAME(),
'Security'[CountryKey],Country[CountryKey]
)
Suddenly ex -USA users to be blocked, again do I need to create role -Country=”USA” and assigning the set of reps to it will it work? Bcoz these reps also part of above dynamic filter by country. In this Case, can I go country wise distribution list and remove USA Distribution list.
I have seen scenarios implemented with path /path contains /lookup values in import method but not same will work on DQ though I enabled allow restricted measures lookup value doesn’t work is there any alternative how to make it work in DQ mode.
Waiting for valuable solution
Hi @Anonymous
For you scenario, you could try "IF", "SWITCH", "RELATED" function in direct query mode.
we can use the function "LOOKUPVALUE" to create measures after going to File -> Options and settings -> Options - > DirectQuery and enable the option “Allow unrestricted measures in Direct Query Mode”.
Best Regards
Maggie
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.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |