Forum Discussion

sxz's avatar
sxz
Frequent Visitor
1 year ago

How to pass multiple parameter values from web application to PowerBI embed for RLS?

I need to pass multiple IDs for RLS purposes.

Currently in other reports I'm using USERNAME() and USERPRINCIPALNAME() functions for that.

Example:

Manage Roles --> set up 2 Roles:

User: UserID = value(USERNAME())

Team: TeamID = value(USERPRINCIPALNAME())

But for this new report I need to pass 4 parameters. Are there other functions?

Need Help

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    Why is USERPRINCIPALNAME() by itself not sufficient?  Do your users have multiple personalities?

    • sxz's avatar
      sxz
      Frequent Visitor
      1 year ago

      So the other IDs are not necessarily needed for RLS. We need to pass additional ID values to filter the report content.

      A user can have access to multiple customers, multiple teams. The dashboard should integrate with the webpage and only show the 1 customer and 1 team they are seeing on the website.
      1 section on the dashboard should also show summary data of all the teams the user has access to as reference.
      Any ideas?

       

      • lbendlin's avatar
        lbendlin
        Super User
        1 year ago

        Use Dynamic RLS to define what the user is allowed to see, and then use Report URL filters to prefilter the team they should focus on.