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...
xabikos's avatar
xabikos
Frequent Visitor
9 years ago

Thanks for the reply varshaneelesh 

We know about the change datasource functionality but it's limited when it comes to change the schema. For example you can design a report against "dbo" schema and then once uploaded to change the datasource to point to "tenantx" schema.

 

In any case we chose to use elastic pool and have one database per tenant which makes the entire set up much easier.

sjungels's avatar
sjungels
Frequent Visitor
7 years ago

Hi all - 

 

has this issue / feature been addressed in the meanwhile? I am trying to find out how to use Power BI Embedded with a single workspace to access a single database using multiple schemas (for multi-tenancy). 

 

Thanks!

  • xabikos's avatar
    xabikos
    Frequent Visitor
    7 years ago

    Hello sjungels 

     

    I don't think something has changed regarding this one. 

     

    As mentioned above we finally used a separate dataase per tenant in the context of an elastic pool which is much easier to understand and maintain.