Forum Discussion
Data Source Security Without RLS
Hi, does anyone knows how to filter rows within a table based on their userprinciplename and organisation hierarchy without using RLS? There are so many roles need to be created in my situation and a...
amitchandak
Super User
Super UserAnonymous , Using userprincipalname means using RLS ?
Employee hierarchy -https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
I don't want to use RLS having said that creating the roles and mapping users to a role is massive work. I want to implement the RLS principle by passing a Power BI user credentials as a parameter in SQL statement. Do you know how?
I know that we can use PATH() for hierarchy, however we will be using Direct Query and I have checked that we couldn't use Paren-Child Dax as this does not support for Direct Query.