Is it possible to filter a report with a username on website ?

[quentin_vigne]

Hi everyone, 

I would like to embed my report in a private webpage but depending on the username (id of the client connected) so that my clients can only see their datas and not others client's data. At the moment my report has a dropdown list with everyclient in my database and I would like to know if it possible to only display values that match my client name/id

Thanks,

Quentin

[Anonymous]

@quentin_vigne,

You can define Row level security in your report.

https://docs.microsoft.com/en-us/power-bi/service-admin-rls

Regards,
Lydia

[quentin_vigne]

@Anonymous

So Instead of having a dropdown list of my clients I can create a client RLS where I type something like MyTable.IdClient = ["Id of connection on my website"] and It will only display values related to my IdClient, is that right ?

Quentin

EDIT : It says :

• External sharing is not currently supported with datasets that use RLS

So embedding my report on a website and trying to make my idclient match will probably not work ? 

[Anonymous · Accepted solution]

@quentin_vigne,

Do you use "Publish to web" to generate embed code of the report? If so, it doesn't support RLS. You can use Power BI embed instead and define RLS.

https://docs.microsoft.com/en-us/power-bi/developer/embedded-row-level-security

Regards,
Lydia

[quentin_vigne]

That's what I was looking for, thanks

Quentin