Row Level Security vs Parameter

Hi lherbert501 ,

There are two ways to solve your problem:

If the report is in Power BI Desktop, you can use Parameter to:

Manage Parameter for your report

Export power bi template

Users can import Power BI Templates in Power BI Desktop

The template will prompt the user to select from the parameters

After specifying the parameter value, a new PBIX file will be created that contains the data of the current user

Deep Dive into Query Parameters and Power BI Templates | Microsoft Power BI Blog | Microsoft Power BI

If you're publishing a report to Power BI Service, you can use RLS:

Create a user information table in the data model that includes the username and user email address that can access the data

Establish a relationship between a user information table and a data table

Create a role in Power BI Desktop that defines filtering for the user information table. Expressions should USERNAME() or USERPRINCIPALNAME()

Publish the report to Power BI Service and add users to row-level security.

Finally, share the report with your customers.

Best Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.