Power BI Row level security with multiple input values.

[Anonymous]

Any one can help me on below scenario.!
- I have a Power BI Report embedded with the API using Report URLs (GroupID, DatasetID, ReportID) from the PowerBI service.

- I am getting the "UserID", "UserRoleID", "ClientID" as the input values from the API.

- I tried withthe UserID=USERNAME() in the modelling tab--> Manage Roles option., but The data is not getting filterd.

- How can I perform the RLS with these three values!?

[lbendlin · Accepted solution]

You have to use USERPRINCIPALNAME, not USERNAME.

Make sure your RLS dimension tables actually control your fact tables in your data model.

[Anonymous]

Hi @Ibendlin,

The Report is working as expected.. Thank you for the help. 😊