Forum Discussion
Multi tenancy power bi embedded reports with separate database per tenant
Hi ,
1.
Please note these limitations:https://docs.microsoft.com/en-us/power-bi/developer/embedded/embed-multi-tenancy?tabs=workspace#power-bi-items
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-instead-of-directquery/
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi ,
1.
Please note these limitations:https://docs.microsoft.com/en-us/power-bi/developer/embedded/embed-multi-tenancy?tabs=workspace#power-bi-items
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-instead-of-directquery/
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.