Power BI

Under Review

PowerView rdlx connecting to on-prem data source

Vote (12)

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)

e55ada53 ca9b-4822-b21a-83aed2505c0c on 05 Jul 2020 23:48:06

RE: PowerView rdlx connecting to on-prem data source

After trialling building a dashboard in Power BI I am surprised to find out this feature doesn't exist for dashboards but inexplicably does for reports. I've passed this on to my management and will now be using Qlik sense for this (which support global filters) and future dashboard development pieces. Also we're cancelling our pro subscriptions since there's little point in having them. I would love to understand better the rationale for not providing this feature but am too time poor to investigate as I have to rebuild a dashboard

ae4ca2a6 f324-43f6-88ef-683c446bbbcf on 05 Jul 2020 23:47:42

RE: PowerView rdlx connecting to on-prem data source

This feature is a MUST for Power BI, if it's Dashboard is to function as all other competing products. Even the simplest of cloud-based dashboard products have such a feature...see Klipfolio, Tibco, and others. Please reconsider this suggestion. Without this functionality, as others have mentioned, the "Dashboard" feature is very weak. This seems like a very simple fix...as you are applying a feature that is already in in the "Report" views under the "synchronize slicer" check-box. There are a LOT of users out there who would like to create a dashboard that reflects multiple KPIs based upon a single selection criteria (including my university students) : - )

e241f27d ca56-4e34-a7d9-c8cae1a35d0d on 05 Jul 2020 23:46:20

RE: PowerView rdlx connecting to on-prem data source

I assumed this would be part of the dashboard. Made three 'tiles' or pages, had a slicer in each one for each site I manage, then found the 'Sync Slicer' option and it worked great. Within PowerBI desktop.

However, when i made a dashboard out of the three tiles, the two that had the hidden synced slicer did not update. They actually only show the last published version from PowerBI desktop and don't even change with the tile being refreshed within the service.

It seems strange to allow synced slicers across multiple pages within a report, but not allow those sliders to update the full dashboard. This would really be helpful, the only other way around it is to make the dashboard look clunky by adding the slicer back to each of the three tiles.

Please add this functionality!

2d9f762a 9625-4755-85fa-cee5d10c82b2 on 05 Jul 2020 23:45:05

RE: PowerView rdlx connecting to on-prem data source

Dashboards are faster when a report needs to show a lot of data and visuals. I originally tried a custom page size 10 times longer than wide, filled it up with everything I needed and it was very...very ...very slow. Scrolling down the page was basically impossible and that was using a premium workspace. I had to move to multiple pages in the report using a synced slicer. Moving those pages back to the dashboard using the pin live page made scrolling through a full report much easier...BUT...this is where the synced slicers across the dashboard would come in handy. If you can't do the synced filters then maybe you could at least pass through the last users filter selection like what is done now. In my example, I create a common report for multiple markets across the country. Each market could go into the Report directly and set their market filter. It stays on their last selection when they come back to the report, it should be a minor thing to pass that same stored selection to the dashboard when they open it. Right now filter selections that get pass with the live page are the defaults selected when the report was last editied.