Pass array in dynamic RLs with embedded report

[roelverm]

I have a PowerBI report embedded in a webapplication.

Authorization and authentication is managed in a separate application and provides us with the information to generate the embed token.

I have created a role called 'insitution ID' which filters the institution table based on the Id's which a user is allowed to see. This information is however not in my powerBI model nor do I want to recreate this in my model as this would create duplicate maintenance.

Users can however have access to multiple institution IDs and this is where I can't get DAX to work as I can only pass a single value

See example below

{

"accessLevel": "View",
"identities": [

{
"username": "12345" --> here I would need multiple values
"roles": [ "InstitutionID"],
"datasets": [ "fe0a1aeb-f6a4-4b27-a2d3-b5df3bb28bdc" ]
}

]

}

See my dax formula

I have tried using an IN operator, but this isn't compatible with the username() function

It does work to have multiple values when I hard code

Is there any way to pass on multiple institution IDs via the username() function or alternatives which don't reqiure me to have an additional table in my model linking the users with all possible institution numbers.

Note that the amount of numbers could go up as high as 100.

Many thanks

[IainColledge]

Did you ever resolve this please as we're facing the exact same situation of needing to pass multiple values to filter on with an "embed for customer" solution?

[Anonymous]

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

[roelverm]

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

[jaryszek]

Hello,

I have the same issue. Did you make this working? 

Best Wishes,
Jacek

[charlottesmn]

Hello @roelverm !
I am faced with the same use case, did you ever figure out a way to do it?

[IainColledge]

It seems to be a common issue, having to pass multiple values to filter on, anyone resolve it?