Forum Discussion
Pass array in dynamic RLs with embedded report
Hi roelverm ,
If 23846 and 23853 are user ids, you can update the formula as below. Later check if it can return the expected result...
In addition, you can refer the following links to get it.
Dynamic RLS - use DAX to return multiple values IN
[Region]
IN CALCULATETABLE (
VALUES ( UserList[Region] ),
FILTER (
ALL ( UserList ),
[User email] = USERNAME ()
|| [User email] = USERPRINCIPALNAME ()
)
)Dynamic Row-Level Security in Power BI with Exclude and Include Rules - RADACAD
[ID] IN
SELECTCOLUMNS(
FILTER(
'User Profile',
Related(User[Email])=UserPrincipalName()
),
'ID',[Profile])Configuring "all" access with dynamic row-level security
Best Regards
Hi Anonymous ,
Thanks for your help, but unfortunately this does not do the trick. The numbers are not user ID, nor do I have a user table as this report will be embedded. I just receive a list of these numbers every time a users logs in via the source application and these numbers should filter the output school table
Looking at the documentation I can only pass a single value, not multiples, but this seems strange as you can have multiple values using the IN statement but this is not compatible with the username() function.
All other examples you provide seem to all work with a user table. If this is really the only way I could check to bring the user table over from the source application, but this seems data duplication and not ideal from maintenance perspective to keep it up to date.
Kind regards,
Roel
Hello roelverm !
I am faced with the same use case, did you ever figure out a way to do it?It seems to be a common issue, having to pass multiple values to filter on, anyone resolve it?
Hello,
I have the same issue. Did you make this working?
Best Wishes,
Jacek
