Multitenancy Solution for Embedded PowerBI Paginated Report

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.