Forum Discussion
One Report to Many Clients
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!
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.
2 Replies
- AlexisOlsonSuper User
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.
- blopez11Super User
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,