How to specify Table filter DAX expression for users belonging to no role using Row Level Security

[Anonymous]

In Power BI Desktop, how do I specify the Row Level Security for Datasets using a Table filter DAX expression for users belonging to no role. I can click 'View as Roles' and specify 'no role' to see how the Power BI report displays for users belonging to no role, but I wanted to find out if there is a way to limit access to certain tables (datasets) using Row Level Security for users belonging to no role using a table filter DAX expression similar to how one would specify this while creating a role. I know that I can limit access to the entire report from the Power BI Report Server for users belonging to no role, but that is not my intent since I only want to limit access to certain tables (datasets) for such users belonging to no role.

[v-cherch-msft]

Hi @Anonymous 

It seems you may try to use Dynamic Row Level Security.For further,please refer to below articles.

https://radacad.com/dynamic-row-level-security-with-power-bi-made-simple

https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies

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,