Filtering rows by client

yehonotan_phy — Tue, 23 Aug 2022 08:47:25 GMT

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.

Re: Filtering rows by client

Anonymous — Fri, 26 Aug 2022 05:44:53 GMT

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

topic Re: Filtering rows by client in Developer

Filtering rows by client

Re: Filtering rows by client