Forum Discussion
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 = ...
Why is USERPRINCIPALNAME() by itself not sufficient? Do your users have multiple personalities?
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?