Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone,
I am having an issue using USERNAME() to create a dynamic RLS. Below is the link to my 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
Solved! Go to 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()
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?
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
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()
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |