Forum Discussion
Charu
Post Patron
Post PatronDynamic RLS hierarchy in power BI report
Hi Everyone, I Couldn't achieve the RLS for organizational hierarchy please help me to get the solution for the following requirement. Using Oracle database direct query mode. When the manager ...
v-yuta-msft
Community Support
Community SupportHi Charu,
Path() is not supported in direct query mode. As a workaround, you may con create Manager ID columns(e.g.: level1, level2, ... ) of each level in hierarchy. The values in each ManagerID columns are their UPNs. You can create a role using measure like [level1] = username() || [level2] = username || ..., then assign members to the role and try again.
Regards,
Jimmy Tao
CharuPost Patron
Post PatronHi v-yuta-msft
Please correct me if I'm wrong, are you saying to create level1, level2, etc in Oracle table and then use those columns in RoLE option.