Skip to main content

Power BI

Under Review

Multi-tenancy scenarios

Vote (155) 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 (23)
Andy Ball's profile image Profile Picture

Chris Staber on 05 Jul 2020 22:25:43

RE: Multi-tenancy scenarios

This one may solve this:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9433560-add-folders-to-organize-reports-on-powerbi-com

Andy Ball's profile image Profile Picture

Rozack 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

Austin 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

Power BI User 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

Ahmad Akra 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

John George Riise 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

Power BI User 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

Douglas Day 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

Jono Luk 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

Arthur Henderson 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.