cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hypeteq
New Member

Multi tenancy power bi embedded reports with separate database per tenant

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

1 ACCEPTED SOLUTION
V-lianl-msft
Community Support
Community Support

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.

View solution in original post

1 REPLY 1
V-lianl-msft
Community Support
Community Support

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.

View solution in original post

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors