Dynamic RLS with USERNAME()

[Anonymous]

Hi everyone,

I am having an issue using USERNAME() to create a dynamic RLS. Below is the link to my PBIX.

Dynamic RLS.pbix

I am puzzled as to why I can't get the dynamic  RLS to function. If you can give me a friendly nudge, I would greatly appreciate it.

Luis

[koushikcs09]

Maintaining data security has become a crucial requirement for businesses today, especially when dealing with BI reporting. With the increasing number of roles involved in data access, managing row-level security (RLS) has become a complex task. In order to provide secure and filtered data access to each role, businesses need to establish a set of filtering dimensions that would be applied to each role. These dimensions could range from profit centers to sales organizations or even trader/buyer codes. The challenge is to create a system that effectively manages these dimensions for each role and ensures their automatic application when users log into each report. Therefore, the question arises - how can businesses create an efficient RLS system that provides secure and filtered data access to each role, without compromising on the performance of BI reporting?

[jiaopengzi]

You can use the tool I developed to manage RLS. The connection between dynamically decoupled RLS and PBIX can be directly managed externally.

The tool supports both Chinese and English.

Tool URL:https://github.com/jiaopengzi/pbi-utils

[Anonymous · Accepted solution]

Got it to work.

Watch out for the quotation marks.

By default, the DAX will be [Username] = "USERNAME()"

To work properly, the DAX should be [Username] = USERNAME()