Douglas Dixon on 07 Nov 2014 01:51:58
Allow me to utilize SSRS PowerView just like I can with Excel PowerView and pin reports to the dashboard, however with SSRS, I would like to connect to on-prem data sources
Administrator on 26 Nov 2014 09:05:18
Hi Doug, thanks for the suggestion. We have another suggestion for connections to on-prem data sources. Can you elaborate on the SSRS Power View requirement? Do you need to upload existing rdlx reports?
- Comments (396)
- Merged Idea (1)
RE: PowerView rdlx connecting to on-prem data source
This is a must-have feature. We need dashboard-level filters and also the ability to keep those selections for different users when they refresh (so they do not have to reselect those filters).
Basically, after sharing the dashboard with multiple people, each person will want to monitor the dashboard using their dashboard-level filters. It will be very annoying to ask them to reselect those filters each time they refresh, especially if that dashboard will be displayed on a projector.
RE: PowerView rdlx connecting to on-prem data source
Global filters are a must. My use of this would be that our company has 400+ locations. The reporting needs to show for their location(s) and it isn't always one location for one user or we could use the RLS. We want the user to set what location s/he is wanting to review and that filter apply to the data they want to see. Then perhaps user will change to another location or a couple of locations and so on. Because there are many users we don't want users to edit reports and have to save them just to store their slicer value. This is a final consideration if we will implement/purchase PowerBI or use something that would have this feature.
RE: PowerView rdlx connecting to on-prem data source
A filter in the dashboard would be excellent. Our internal customers would like to be able to choose themselves which slice of the data they want to see rather than us managing the view for them via roles or hard coded means (our Mercury security filters determine whether they can see data and to what extent in any case).
The current work around for not having a global filter for us is to have as many dashboards as there are filters, linked through one uber dashboard. While the user can get what they want this way, we are maintaining 5 dashboards instead of one, which is not workable from our maintenance resourcing perspective.
RE: PowerView rdlx connecting to on-prem data source
Hello,
Just wanted to share my experience with slicers on dashboards. I have successfully added slicers to a dashboard by simply pinning the entire report using, "Pin Live Page". But this doesn't resolve my mobile app rendering of my dashboard. Pinning the tiles individually is more aesthetically appealing when viewing on my phone, but no slicers.
good luck!
RE: PowerView rdlx connecting to on-prem data source
I just need to be able to create filters that applys to several pages.
RE: PowerView rdlx connecting to on-prem data source
It would be nice to be able to control the filter by the REST API, too. Here is our use case. Our app has > 1 "tenants", each of whom wants to see his/her own slice of data across a dashboard comprised of many report pins. When such a tenant clicks the "dashboard" button in our app, we'd like to launch PBI with the appropriate filters set as expected by the tenant. There are no cross-tenant data visibility restrictions, so if tenant X wants to see tenant Y's data slice, that's fine. But most of our users are not PBI savvy, so we want to launch their dashboard set the way they will expect (see my own data slice), Finally, each tenant is >= 1 AAD user.
RE: PowerView rdlx connecting to on-prem data source
Could be great if we can previously select some values for our filter before moving on the dashboard. I have a lot of different values in one of my field which will be my filter, but I don't want all I just want 4 or 5 of those. In the other hand, I did not find an option to select multiple values when I use the filter icon. thanks.
RE: PowerView rdlx connecting to on-prem data source
Please consider also if one could make the filters default to certain values for specific users. For example, one user would like to see by default a slice of the data when he logs in, other would follow suit. Also, is there a way for the filters to remember the last value selected? That could definitely help with selection persistence in between sessions.
Thank you,
John
RE: PowerView rdlx connecting to on-prem data source
YES. I NEED THIS ASAP
RE: PowerView rdlx connecting to on-prem data source
This is absolutely a must-have feature. Live-filtering on a live dashboard is extremely useful.