How to send a list of values in CUSTOMDATA string and use it in a powerbi report (RLS/Embed token)

[Anonymous]

Hi,

I'm trying to integrate a PowerBi-report inside an Asp.net Core Web application. I generate the Embed-Token using the Microsoft.PowerBi.Api NUGET package.

I would like to filter what the user can see using a combination of username and customdata. Right now im able to sucessfully view a report with username and one value in customdata. But I would like to include several string values inside customdata eg.: "'id1','id2', 'id3'" and use the values in IN(CUSTOMDATA()). How can I do this? To generate the token I can only send in CUSTOMDATA as a string.. So how can I split CUSTOMDATA() into a list of values using DAX in the report?

Do DAX have any string.Split functionality or similar available?

Thx

[v-shex-msft · Accepted solution]

Hi @Anonymous,

Customdata is an information function, and I'm not so sure if it allows advanced customize. You can try to use the following formula with path function to expand a text to list:

VAR _path =
    SUBSTITUTE (
        CONCATENATEX ( VALUES ( 'Table'[Column] ), [Column], "," ),
        ",",
        "|"
    )
VAR _length =
    PATHLENGTH ( _path )
VAR _pathtable =
    ADDCOLUMNS (
        GENERATESERIES ( 1, _length, 1 ),
        "Column", PATHITEM ( _path, [Value] )
    )

In addition, I'd like to suggest you mapping these records in your tables and use RLS to filter them.

Regards,

Xiaoxin Sheng