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

[sxz]

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?

[lbendlin]

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

[sxz]

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]

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.

[sxz]

Good idea, I'll def give that a try. Thank you!