Forum Discussion

xabikos's avatar
xabikos
Frequent Visitor
9 years ago

Power Bi embedded schema based multi tenancy

We are currently evaluating the Power BI embedded platform in the context of a cloud based solution we offered to our clients. Our software is multi-tenant and to achieve this one we use database...
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi xabikos,

 

In this scenario, I would suggest you to create a new schema to put all data into it, and design reports against this schema, then use Row level security with Power BI to restrict user access to particular data within a report or dataset, allowing for multiple different users to use the same report while all seeing different data. 

 

Reference:

Row level security with Power BI Embedded

Row-level security (RLS) with Power BI

 

Regards

xabikos's avatar
xabikos
Frequent Visitor
9 years ago

Hello v-ljerr-msft and thanks a lot for the answer.

 

Maybe the question was not entirely clear but for our use case Row Level Security is not a option for us, at least for now. Maybe in the end we will be forced to do that but we have strong doubts about this solution, not only for data isolation but for scaling reasons as well.