https://community.fabric.microsoft.com/t5/Developer/Would-PowerBI-embedded-work-with-AWS-stack-for-a-multi-tenant/m-p/126086#M4362 <P>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.</P><UL><LI>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?</LI><LI>Also would it be recommended to change the architecture of the application in this situation?</LI><LI>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?</LI><LI>There is this old post suggesting PowerBI embedded does not do row level security <A href="https://community.powerbi.com/t5/Developer/Multi-tenancy-with-Power-BI-Embedded/td-p/32148" target="_blank" rel="nofollow noreferrer">https://community.powerbi.com/t5/Developer/Multi-tenancy-with-Power-BI-Embedded/td-p/32148</A> but then there are these recent docs <A href="https://docs.microsoft.com/en-us/azure/power-bi-embedded/power-bi-embedded-rls" target="_blank" rel="nofollow noreferrer">https://docs.microsoft.com/en-us/azure/power-bi-embedded/power-bi-embedded-rls</A> suggesting they do support it, can this be used in my situation?</LI></UL> Mon, 13 Feb 2017 03:08:54 GMT dhruvsakalley 2017-02-13T03:08:54Z https://community.fabric.microsoft.com/t5/Developer/Would-PowerBI-embedded-work-with-AWS-stack-for-a-multi-tenant/m-p/126086#M4362 <P>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.</P><UL><LI>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?</LI><LI>Also would it be recommended to change the architecture of the application in this situation?</LI><LI>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?</LI><LI>There is this old post suggesting PowerBI embedded does not do row level security <A href="https://community.powerbi.com/t5/Developer/Multi-tenancy-with-Power-BI-Embedded/td-p/32148" target="_blank" rel="nofollow noreferrer">https://community.powerbi.com/t5/Developer/Multi-tenancy-with-Power-BI-Embedded/td-p/32148</A> but then there are these recent docs <A href="https://docs.microsoft.com/en-us/azure/power-bi-embedded/power-bi-embedded-rls" target="_blank" rel="nofollow noreferrer">https://docs.microsoft.com/en-us/azure/power-bi-embedded/power-bi-embedded-rls</A> suggesting they do support it, can this be used in my situation?</LI></UL> Mon, 13 Feb 2017 03:08:54 GMT https://community.fabric.microsoft.com/t5/Developer/Would-PowerBI-embedded-work-with-AWS-stack-for-a-multi-tenant/m-p/126086#M4362 dhruvsakalley 2017-02-13T03:08:54Z https://community.fabric.microsoft.com/t5/Developer/Would-PowerBI-embedded-work-with-AWS-stack-for-a-multi-tenant/m-p/126957#M4383 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="21414" data-lia-user-login="dhruvsakalley" class="lia-mention lia-mention-user">dhruvsakalley</a></P> <P>RLS for Power BI Embedded is announced&nbsp;and it seems to be your savior, any concern?</P> Tue, 14 Feb 2017 11:23:38 GMT https://community.fabric.microsoft.com/t5/Developer/Would-PowerBI-embedded-work-with-AWS-stack-for-a-multi-tenant/m-p/126957#M4383 Eric_Zhang 2017-02-14T11:23:38Z https://community.fabric.microsoft.com/t5/Developer/Would-PowerBI-embedded-work-with-AWS-stack-for-a-multi-tenant/m-p/127220#M4389 <P>Thanks for confirming this, I'll do a POC soon and will let you know :)</P> Tue, 14 Feb 2017 18:36:20 GMT https://community.fabric.microsoft.com/t5/Developer/Would-PowerBI-embedded-work-with-AWS-stack-for-a-multi-tenant/m-p/127220#M4389 dhruvsakalley 2017-02-14T18:36:20Z