Forum Discussion
One Report forMmany Clients
Good afternoon everyone. How are you doing?
I am modeling a report that will be used by multiple clients and one client can't see another client's data.
I have tried several models but did not get good results. Does anyone have any suggestions on how I can do this modeling?
I am using Power BI Embedded as the product.
Thank you very much!
Hi Anonymous
You want to look at Row Level Security. This allows Power BI to be aware of the users login name, and compare that with the Data in the model to allow or deny access. So when they log in each client can only see records that are tagged with their client name.
Things are a little different with Embedded, but this document explains all you should need to know.
Hope this helps
Stuart
1 Reply
- Burningsuit
Resident Rockstar
Hi Anonymous
You want to look at Row Level Security. This allows Power BI to be aware of the users login name, and compare that with the Data in the model to allow or deny access. So when they log in each client can only see records that are tagged with their client name.
Things are a little different with Embedded, but this document explains all you should need to know.
Hope this helps
Stuart