Power Bi embedded schema based multi tenancy

[xabikos]

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 schema based isolation. This means that many tenants share one database and each tenant has a dedicated schema as you can see in the picture on the left.

For every tenant we have a dedicated workspace inside a single workspace collection. Our workflow is to design the reports against the dbo schema and then upload the pbix file in all the workpspaces in order to make it available for all the tenants. So far we haven't found a way to update the report's datasource to point in the correct schema. As far as I know there is the option to update the connection string via the rest api after you upload the report but there you can't set the schema.

On top of that we also tried to create a database user for each tenant and assing this user to only access this schema. Then when we updated the datasource we set as credentials the one from the database user, hopping that the database would point to the report to the correct schema but this didn't work either.

Does anyone has faced something similar or have any idea how we could bypass this issue?