Multi tenancy power bi embedded reports with separate database per tenant

[hypeteq]

We are developing one saas web application, every customer will have diffrent sql database in azure under single sqlserver and each database have same schema

As of now we have done as per this document :

https://docs.microsoft.com/en-us/power-bi/developer/embedded/embed-multi-tenancy?tabs=workspace

For genrate report:

1. Add poerbi premium free trial.
2. Genreate one dataset and one report in powebi desktop.
3. Publish report in poerbi workspace.

For embedded in web application.
1. Genreate AAD Token
2. Genreate embedded token and show report in web application.
3. Create workspace and clone report but its point to same dataset.

Now my doubts are as per below:

1. As per document we need to create separate workspace,dataset and report of every customers
- TO achice this which powebi product need to use. premium per user or premium per capcity.
- There will be more than 1000 customer.
2. How to create/copy dataset with diffrent connection using api?
3. Show realtime data in report from sqldatabase

[V-lianl-msft · Accepted solution]

Hi ,

1.

Please note these limitations:https://docs.microsoft.com/en-us/power-bi/developer/embedded/embed-multi-tenancy?tabs=workspace#powe... 

2.

Though we can't clone the dataset directly, there could be a workaround. The change is only the data source.

Upload the pbix file with imports/postimportingroup.

Update the data sources with datasets/updatedatasourcesingroup. 

3.

Both Push Datasets and DirectQuery are OK,Push datasets are an efficient and inexpensive way to implement real-time updates in Power BI reports and dashboards. https://www.sqlbi.com/articles/implementing-real-time-updates-in-power-bi-using-push-datasets-instea... 

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