Forum Discussion
Dynamic RLS with USERNAME()
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
3 Replies
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
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?
