Skip to main content

Power BI

Under Review

Multi-tenancy scenarios

Vote (152) Share
Andy Ball's profile image

Andy Ball on 31 Jan 2015 16:56:24

We would love to use Dashboard to publish reports for our customers but would want to separate out by customer - ie have separate sub areas / folders per customer , where we can permission per customer - ie only users in relevant Customer group has permission to the folder



Comments (22)
Andy Ball's profile image Profile Picture

9e5983c5 f031-41c5-892a-f4e4b37ab191 on 05 Jul 2020 22:24:53

RE: Multi-tenancy scenarios

Hi Jono,

We are trying to use the PowerBI embedded and we do not see any features by which we can Publish a report template and restrict the access to the data (user wise scope / row level security). We are using SSAS cube as the source.
The system is multi-tenant system.

Andy Ball's profile image Profile Picture

6c00c661 34d9-4c69-97f0-b1e411d3e5e6 on 05 Jul 2020 22:22:09

RE: Multi-tenancy scenarios

This would be a great partner resource!

Andy Ball's profile image Profile Picture

3a6c7204 7de5-4183-8bc2-6c86cd966a4e on 05 Jul 2020 22:21:52

RE: Multi-tenancy scenarios

Our multi-tenant scenario is simple: we would create the report and then publish it on our portal so that our clients (we are multi-tenant SaaS) can run/visualize the report. But the data used at runtime to build the report for a particular client should only contain the data that belongs to that client. In other words, I need to be able to select/filter the data by a single "Client ID" parameter. Right now we can put a filter in the URL as in:

https://app.powerbi.com/reportEmbed.../$filter=clientID eq 332

but this is not secure as any client can simply change the URL and access someone else's data. What is needed is for Microsoft to let us embed additional claims into the App Token. When building the App Token, we would add a few additional claims such as "$ClientID=35" and "$UserID=444" and then Power BI would simply feed those claims to the Power BI engine (Of course, the report in this example is designed to take 2 parameters).



Andy Ball's profile image Profile Picture

c3164fb9 011c-4afa-91fc-3bde64e0ee47 on 05 Jul 2020 22:21:49

RE: Multi-tenancy scenarios

We offer a SaaS multi-tenant system on the cloud using Azure SQL sharding, the system is for enterprises. it would be fantastic if Power BI could facilitate the scenario where we want to provide web dashboards for our clients executive offices where every client/tenant can view and analyse their subset of the data without being aware of the existence of the other clients/tenants

Andy Ball's profile image Profile Picture

1b885140 ac43-4da6-8848-c83cf13190dd on 05 Jul 2020 22:19:15

RE: Multi-tenancy scenarios

We are also interested in this and whether the users already are Power BI users or not is secondary. Of cause the fewer constraints the better. But what are the options?

Andy Ball's profile image Profile Picture

44aa855c e820-48d5-ba0b-a82e6e13c401 on 05 Jul 2020 22:18:59

RE: Multi-tenancy scenarios

I have the same problem, because we need use te same report for different clients, but we need applied a filter with id customer.
Thanks much!
Charly

Andy Ball's profile image Profile Picture

eb6d3d85 fe60-4e70-8106-52e3dbe93266 on 05 Jul 2020 22:18:44

RE: Multi-tenancy scenarios

I also very interested in understanding how we can host \ manage multiple clients data on one or more tenants.

Andy Ball's profile image Profile Picture

7e7e1c79 e137-46a4-a93c-2ac5a6c5f4c5 on 05 Jul 2020 22:17:52

RE: Multi-tenancy scenarios

Hi everyone,

Thanks for your comments here. I'd like to make sure I'm clear on your request here. Are you saying that you want to build Apps for your own customers, and manage the reports, datasets that are used for those reports? In general, do these users already have Power BI? Or are you thinking that they wouldn't necessarily be using Power BI already?

Thanks much!
Jono

Andy Ball's profile image Profile Picture

92199619 7895-4ca7-a521-a66450d8d766 on 05 Jul 2020 22:17:40

RE: Multi-tenancy scenarios

We would love to see this feature for our healthcare and Government clients. Clarification on how MS intends us to support external clients would also be appreciated.

Andy Ball's profile image Profile Picture

aa15023c 20e6-4c67-80bb-de1d41ac678b on 05 Jul 2020 22:17:31

RE: Multi-tenancy scenarios

As part of the multi-tenancy requirement, Pro License users in different groups must not be able to collaborate with one another nor see one another when adding/editing workspaces.