Multitenancy Solution for Embedded PowerBI Paginated Report

[Anonymous]

I am trying to embed my paginated reports in angular application. Its a multitenant application and the model is Databse per tenant)

Following is the requirement:

1) We have different database for different set of customers (ie., DB1 for CustomerSet1 and DB2 for CustomerSet2).

2) When a customer from CustomerSet1 logs into application, he should see the paginated report related to the data in DB1.

Following is the solution I came up with:

I will create a seperate workspace for each DB (Workspace1 for DB1 and Workspace2 for DB2).

Problem:

This solution needs manual intervention,

1) We have to create workspace everytime a new DB is added.

2) We have to republish all the reports everytime.

Question:

Is there a way to avoid manual intervention everytime a new DB is created? Is there a better solution to this? 

NOTE:

I also tried with the USERID concept of getting the USERID as a parameter value. But I am not able to pass the datasource dynamically in the connection string.

[Anonymous]

Hi @Anonymous ,

I appreciate you for replying.

I have tried both of the solutions that you mentioned but in vain.

For Row-level security with Power BI Embedded, I was not able to pass the datasource dynamically in the PowerBI Report builder connection string.

Do you have a solution for this?

For Multi-tenancy solutions with Power BI embedded analytics, 

1) We have to create workspace everytime a new DB is added.

2) We have to republish all the reports everytime.

Do you have a solution for this 1 & 2?

Thanks & Regards,

Ramamani

[freddycastro]

Have you found a solution to this issue.  I have a similar issue and haven't been able to find anything to help me.  

[Anonymous]

Hi @Anonymous ,

According to your statement, I think you want to restrict data by user. Here I suggest you try RLS in Power BI.

For reference:  Row-level security with Power BI Embedded

Here is an offical blog about Multi-tenancy solutions with Power BI embedded analytics

Best Regards,
Rico Zhou

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