I’m trying to deploy Power BI Embedded into our app, but I have some issues to resolve with our multi-tenancy and Direct-query
We have one server that include one database for each of our clients. The schema is the same across all the different customer databases.
Since the data is in each database, I do not see we can use Row Level Security.
So far, the only way I can see it works is by creating one Workspace / report for each client / database, which it is far from ideal.
Anyone has experience in this type of deployment or a different approach?
Thanks in advance.