Would PowerBI embedded work with AWS stack for a multi-tenant application, given a single database?

[dhruvsakalley]

We have a SQL Server 2016 instance containing multi-tenant data (tenantID column in each table), hosted in AWS EC2. We have an angular/Web-API application which needs to render reports. I'm trying to understand if PowerBI embedded can work this way, the application uses a single database user for connecting to the database, not a per tenant user.

• I'm struggling to understand how can I set up the tenant-wise access in this given situation so that a tenant's report does not pull other tenant's data?
• Also would it be recommended to change the architecture of the application in this situation?
• PowerBI has a beta connector for AWS Redshift, would it make sense to have a Redshift cluster for each tenant, or would this break the bank?
• There is this old post suggesting PowerBI embedded does not do row level security https://community.powerbi.com/t5/Developer/Multi-tenancy-with-Power-BI-Embedded/td-p/32148 but then there are these recent docs https://docs.microsoft.com/en-us/azure/power-bi-embedded/power-bi-embedded-rls suggesting they do support it, can this be used in my situation?

[Eric_Zhang · Accepted solution]

@dhruvsakalley

RLS for Power BI Embedded is announced and it seems to be your savior, any concern?

[dhruvsakalley]

Thanks for confirming this, I'll do a POC soon and will let you know 🙂