The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
I am in the process of building a multi-tenant application that requires visualizations. I am exploring PowerBI embedded for this purpose. I cannot use Power BI's row level security as data from each tenant cannot be in proximity to another tenant's data.
Each client will have different data sources but will need access to the same PowerBI report template. The only difference between clients and their reports will be the data sources their report points to.
Here's how I am approaching this problem:
My concerns with this approach are the following:
How does this approach sound? Are there more sensible alternatives for my desired result?
Any input would be greatly appreciated!
Hi @SuperTommy,
I have also written a blog post on this topic that may give you some more insights.
Thanos
Hi @SuperTommy,
we have implemented a similar solution. I have already shared some of the implementation decisions in this answer.
Hope this helps.
Regards,
Thanos
There are some limits with the current Power BI REST API.
So I am afraid currently there is no proper way to overcome some of your concerns.
1. For security concern, please consider add authentication to your Application,
2. You may take a look at the following blog, which may help in your scenario,
3. If each group represents a different tenant, it is recommendded to have it in different workspaces,
4. Consider set up Data Refresh, you could re-bind Power BI Reports to the proper dataset with the Rebind API:
https://msdn.microsoft.com/en-us/library/mt784672.aspx
Regards,
Michael
Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.
User | Count |
---|---|
17 | |
2 | |
2 | |
2 | |
1 |
User | Count |
---|---|
19 | |
10 | |
5 | |
4 | |
3 |