Row level security with multiple roles

Thank you Dale,

I understand the solution(The rules of Role1 is client_id = 2 and location_id =1". If you want some data of where the location_id is only 1, there will be a role, let's call it Role 3, with rules "location_id = 1"). 

But, i cannot hardcode the location id and client id in role(like "location_id = 1" and client_id = 2), where i am embeding the report into web application, i won't be knowing which client and location user logged in to application(Location and client id is dynamic always).

When i logged in to web application and when the reports rendered through power bi rest api,  i should be seeing only respective client and respective location report data.

I have rised this question with respect to report embed on webapplication.

Thank you

Pallavi