Multitenancy users with single workspace in powerbi embed

[ViralGajjar2904]

For the past 20 days or so, I've been following Service principal profiles for multi-tenancy apps in Power BI Embedded to try and understand if there is some way to make Power BI work with our use case (it's a SaaS product with one database per tenant that's hosted in Azure with 1000+ tenants), and at the moment I am stuck. Let me first describe what I've tried.

Approach: Single Workspace for all tenants, single reporting database

I Want to embed powerbi report in Client's application which serves 1000 of tenants.I want to use Service principal profiles for multi-tenancy apps in Power BI Embedded but using Single Workspace.I know the process which starts with profile creation ,give permission,workspace creation,report publish & embed report.
But my doubt is how can I perform all steps using only single workspace.

Any input on how to integrate Power BI into our use case would be appreciated.

[v-zhengdxu-msft · Accepted solution]

Hi @ViralGajjar2904 

You can try the following workaround, but this requires some familiarity with API interfaces or Power Shell.

This link can help:

Embed Power BI content in an embedded analytics application with service principal and an applicatio...

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SaiTejaTalasila]

Hi @ViralGajjar2904 ,

Please check this -

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-embed-secure

If you have a premium capacity then you can monitor your interactive cpu to understand how well your application is performing or is it causing any overload.

Thanks,

Sai Teja 

[lbendlin]

small side note:  You will run into workspace limitations

Workspaces in Power BI - Power BI | Microsoft Learn