Forum Discussion
Power Bi embedded schema based multi tenancy
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.
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!
