Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I am trying to use Row Level Security for my Power Bi model and for that I am using username() function to get the filters. The thing is that I have two filters to pass and thus would like my username() function to be able to take 2 values. Is there any way of doing it ?
Solved! Go to Solution.
Not quite sure if this is what you're looking for, but I do something similar using LOOKUPVALUE. Basically I find where USERNAME() matches the Email in the Users table and then filter the Programs table where either the returned Program 1 or Program 2 match. The filters on the Programs table then flow to all the other tables in my model.
Programs
Program
Users
User 1 Email Program 1 Program 2
My RLS set up in the Programs table is:
[Program] = LOOKUPVALUE(Users[Program 1], [Email], USERNAME()) || [Program] = LOOKUPVALUE(Users[Program 2], [Email], USERNAME())
Not quite sure if this is what you're looking for, but I do something similar using LOOKUPVALUE. Basically I find where USERNAME() matches the Email in the Users table and then filter the Programs table where either the returned Program 1 or Program 2 match. The filters on the Programs table then flow to all the other tables in my model.
Programs
Program
Users
User 1 Email Program 1 Program 2
My RLS set up in the Programs table is:
[Program] = LOOKUPVALUE(Users[Program 1], [Email], USERNAME()) || [Program] = LOOKUPVALUE(Users[Program 2], [Email], USERNAME())
This solution works perfectly but I was confused on the second part "The filters on the Programs table then flow to all the other tables in my model"
I am trying to filter other tables with no user info in them but has relation to programs. And I try to filter other table based on the programs table I am not able to filter that.
This solution works perfectly but I was confused on the second part "The filters on the Programs table then flow to all the other tables in my model"
I am trying to filter other tables with no user info in them but has relation to programs. And I try to filter other table based on the programs table I am not able to filter that.
Thanks that worked perfectly.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
37 | |
31 | |
26 |
User | Count |
---|---|
94 | |
50 | |
43 | |
40 | |
35 |