Forum Discussion
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 differen...
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:
- 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)