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 = ...
Need Help
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.

  • sxz's avatar
    sxz
    Frequent Visitor
    1 year ago

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