cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bunceg Frequent Visitor
Frequent Visitor

Slice dashboard by tenant

Hi,

 

This question may be a fundamental misunderstanding on my part about the target audience for Power BI, but is it possible to have a single dashboard, published to the web, that shows different data by tenant.

 

i.e. we have an existing website where users login (using our own OAuth2 service based on ThinkTecture) and are then limited to their own data set. The database could be sharded, but at the moment it isn't. However, even if it was, we could have multiple tenants in the same shard anyway.

 

What I need is a system where I can quickly create charts and pull in content from different sources and push them to the web for access from within our site, but the data is specific to the current logged in user.

 

As we use Azure, and Azure SQL, Power BI seemed perfect, but it looks like it targets internal business customers only (and authentication via AD only), not our kind of requirements.

 

Is what I need possible with Power BI?

 

Thanks

7 REPLIES 7
ashishrj Senior Member
Senior Member

Re: Slice dashboard by tenant

@bunceg You can use SSAS tabular modeling and create roles for restricting access to data for different users and later pull data in Power BI to create reports/dashboards. Also same can be scheduled for refresh. Hope this helps!

bunceg Frequent Visitor
Frequent Visitor

Re: Slice dashboard by tenant

We don't have SSAS installed I'm afraid.

 

We have kept our architecure to a bare minimum of the default SAAS services Microsoft provide, i.e. we use SQL Azure not a VM with SQL Server, Web Apps and Cloud Services instead of VMs etc.

 

We really don't want to install a SQL server instance on a VM to support this - in effect our requirements are simple:

 

  • The same dashboard for every user, therefore
  • The same queries for every user
  • The content to be sliced based on their tenant (and therefore based on some claim such as customer id, from their credentals)

 

andre
Advisor

Re: Slice dashboard by tenant

@bunceg you should probably create a Content Pack and work with Microsoft on having that deployed with the service.  (I am not talking about Organizational Content packs, you should create one similar to Google Analytics and Quickbooks)

mstefancik Member
Member

Re: Slice dashboard by tenant

This is quite interesting question. I am also curious about ways how to achieve described. As it does not make sense to create same dashboard for every single user.

Can anybody share his experience?

What in the case three managers want to take a look into one dashboard, but to be able see only theirs data?

What in the case if the datasource is MS SQL Server, on the other hand what in the case data come from excel? Is it possible to use some parametrization, code web service, where to get information who is logged in?

 

bunceg Frequent Visitor
Frequent Visitor

Re: Slice dashboard by tenant

Urg... I really can't see that happening? Asking Microsoft to do some work for us?

 

I will look into content packs but from the sound of it, this looks like a "can't be done, this isn't the user scenario we set Power BI up to do"...

andre
Advisor

Re: Slice dashboard by tenant

@bunceg Unfortunately, I don't know the official channel to get in touch with the MS Prod team regarding creating a custom content pack.  You should contact your local Microsoft account team and request that they get you in touch with the right folks.  Or you can try to PM some of the MS folks who post here.  My understanding is that MS thinks of content pack as a very important part of Power BI so I would guess that you should have some good luck getting this going.

ThomasDay Established Member
Established Member

Re: Slice dashboard by tenant

Yes, it sounds like we're on the same page, though our use case is even easier.  A set of "custom" reports for each user---they log in and go to their custom dashboard/report only.. and importantly these users are clients of ours--not internal to our company.

 

They see their dashboards or reports only, no easy click access to data model--except thru the visualizations.  

 

Does that sound impossible?

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,132)