One Report to Many Clients

[Anonymous]

Good afternoon, everyone. How are you?

I'm modeling a report that will be used by several clients and one client can't see another client's data.

I have tried several models but have not achieved any good results.. Does anyone have a suggestion on how I can do this modeling?

I am using Power BI Embedded as the product.

Thanks a lot!

[blopez11]

Agree with @AlexisOlson You can use row level security and have the application maybe pass in a client ID through to Power BI for it to use to filter the data.  The guy in a cube video below may shed some light

https://www.youtube.com/watch?v=yNF-_l2f7w0

Good luck,

[AlexisOlson · Accepted solution]

Have you looked into Row Level Security?

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

Otherwise, you'll probably want separate datasets for each client.