Forum Discussion
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...
I was looking at a very similar usecase for myself. I found this link https://docs.microsoft.com/en-us/azure/power-bi-embedded/power-bi-embedded-iframe, which explains how you can change the datasource config after the report is uploaded into the workspace. See the section "Data source connectivity (and multi-tenancy of data)".
Hope this helps.
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.