Forum Discussion
Power BI Row level security with multiple input values.
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!?
You have to use USERPRINCIPALNAME, not USERNAME.
Make sure your RLS dimension tables actually control your fact tables in your data model.
2 Replies
You have to use USERPRINCIPALNAME, not USERNAME.
Make sure your RLS dimension tables actually control your fact tables in your data model.