But using this method one user is able to see data of other user by editing the data in the browser. Is there any secure way of doing the filtering for Power BI reports hosted on Power BI report server?
We create our own authentication provider on top of PBI RS. We don't use the out of the box AD provider. Also, is the pbix using a direct connection or an import model? You can use RLS with both implementations.
Thank you for your quick response and help. With row level security we need to always add members and we have 100+ customers and with every new customer we will have to manage addition or deletion of members. Is there a workaround for this?