Filtering rows by client

[yehonotan_phy]

I am developing a PowerBI Embedded application using React. What I need is to filter out rows by parameter client_id in table client. There're few options found but none is good to me. Maybe, there's a different way?

1. Using PowerBI RLS. This is not good, because I need to create Microsoft user for everyone.

2. Filtering by adding hidden filter into my application. Not good, because user might open his browser's Developer tools and figure out how to change the filter.

I need a way to get token for already filtered report and without creating thousand users.

Thanks for any help.

[Anonymous · Accepted solution]

Hi @yehonotan_phy ,

Which embedded analytics solution you are using? If you are using Embed for your customers, you can refer the following links to achieve it. The embed for your customers solution allows you to build an app that uses non-interactive authentication against Power BI, and the customers don't need to sign in using Power BI credentials to view the embedded content. 

Power BI embedded analytics

Row-level security with Power BI Embedded

Best Regards