topic Re: How to pass multiple parameter values from web application to PowerBI embed for RLS? in Developer

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

sxz — Wed, 09 Oct 2024 14:07:47 GMT

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?

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

lbendlin — Wed, 09 Oct 2024 15:28:50 GMT

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

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

sxz — Mon, 14 Oct 2024 19:38:15 GMT

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?

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

lbendlin — Mon, 14 Oct 2024 19:49:37 GMT

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.

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

sxz — Mon, 14 Oct 2024 19:56:31 GMT

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