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?
@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!
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:
@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)
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?
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"...
@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.
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?
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!