I am trying to implement the `app owns data` embedded flow for power Bi. I have been succesfull in creating a report, publishing it and displaying it on a webpage with the embed url, token and stuff... that is not the problem.
Now I am trying to setup the reporting so we have 1 (or 1 per tenant) report with each of them containing their own data. Let me give you some context:
We have an SQL database per tenant (they can also host the DB themselfs), all the databases have the same schema and have the same reports. We need a convenient way (with the REST API's or minimal effort) to add a new Tenant to our application.
How do I achieve this with 1 embedded licensed workspace? This is a requirement because we don't have global admin in azure thus we cannot create new Tenants for the application when needed (like microsoft recommends).
This I have tried:
What doesn't work:
- Modify datasource while it is embedded -> all embeddings are updated live with new data, so the tenants could see other reports when viewing them together.
- Copy of report to get new semantic model -> semantic modeldoes not get new copy, so we cannot modify it
- Create own new semantic model -> gateway needed and can only be done for onpremise? Push dataset doesn't seem like the right use case either
- Dateflow cannot be used directly for report -> a semantic model has to be made of it first
What might work:
- Connecting multiple databases with the same semantic model and then filtering? really no idea about this
- Maybe somehow copy both a semantic model and report (so we get a new semantic model and report per tenant) and then we can modify the datasource connection string in code?
I have tried different things all day but did not have any success with the multitenancy. If anyone has more insight to this, please help!
