Forum Discussion
app-own-data multiple sources
Hi all, Just a question from a product perspective. We create custom software as a SaaS, each customer of the software has its own database to which the cloud platform connects. (Customer data i...
Yes indeed, they will al have their own data warehouse/semenatic model per customer.
So with automation, it means we should create a report, a semantic model per customer. Does it also means we need a entra ID per customer as well to secure it and integrate this in the web app?
And how would you manage the user security level?
Thank you for your reply!
Based on your requirements where you said you would need a database per customer, I would then follow the same way in fabric. You can still apply Row Level Security when using a Warehouse on either the SQL End Point or on the semantic model depending on where you want to surface the data.
