Skip to main content

Power BI

Under Review

PowerView rdlx connecting to on-prem data source

Vote (12) Share
Douglas Dixon's profile image

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)
Douglas Dixon's profile image Profile Picture

ca64d339 3581-492f-b87b-d0b4ed8394d3 on 05 Jul 2020 22:23:36

RE: PowerView rdlx connecting to on-prem data source

This would be great. We have a lot of power view reports in on-prem sharepoint 2013. There needs to be a way to migrate these to Power BI without reauthoring them all from scratch. I can't open rdlx files in Power BI Desktop nor upload them via the 'Get Data' functionality online.

Douglas Dixon's profile image Profile Picture

6d648d8d c764-4c32-b1a3-5fa683e80255 on 05 Jul 2020 22:23:16

RE: PowerView rdlx connecting to on-prem data source

The omission of Filters on a Dashboard is very limiting and certainly hinders our take up of this application. We are relatively new to PowerBI, and so far have built filters into the reports especially when using Analysis Services as a source. It allows a single set of tiles to be developed which can be reused. The use of Filters means that we can base an entire report off several different aspects of the business.

Often the tiles are grouped into a single report because they are supportive information needed as a collective. e.g. across a specific timeframe.

Our managers also favour the use of Dashboards via mobile devices, but the lack of filter means that we have no way to re-target the filter for a report into a Dashboard.

Although it is possible to drill into each tile and fire a single filter we have also noticed that the report filters do not always map upwards to the Dashboard as expected.

It would be nice to be able to define a report entirely into a Dashboard including report filters

Douglas Dixon's profile image Profile Picture

c7dc6d1a 878a-4be9-94af-78da3f643d6a on 05 Jul 2020 22:23:06

RE: PowerView rdlx connecting to on-prem data source

Another MUST have feature! Good to know it is planned but would be great to know more details when this is going to be available. "feedback in a couple of months" is too vague and does not allow us to do any planning.

Douglas Dixon's profile image Profile Picture

318099c5 7ac9-45da-bf60-5dcf48ee04ba on 05 Jul 2020 22:23:01

RE: PowerView rdlx connecting to on-prem data source

Really needed, would make life much easier. For starts it should allow filter multiple reports from the same source but then in the future if you have sales report and operative report with same organization hierarchies you should be able to filters those..

Douglas Dixon's profile image Profile Picture

4420ce05 43c9-486f-8d49-5d29440c0bb4 on 05 Jul 2020 22:22:13

RE: PowerView rdlx connecting to on-prem data source

This is needed. I don't understand why it would be excluded when everything else can be pinned to the dashboard.
I'm new to Power BI, is there a way to specify a filter like:
where PROJECT Contains "name"

Douglas Dixon's profile image Profile Picture

17a65e69 ad5f-4ed8-8fbb-bfe7912d2110 on 05 Jul 2020 22:22:04

RE: PowerView rdlx connecting to on-prem data source

'Better to put filters in dashboard level also, because dashboard is a initial page they need to see the filter data in dashboard it self with out going to individual reports

+1 from me!

Douglas Dixon's profile image Profile Picture

ceb35b8a b0e6-4c37-b65a-60c9fee696b4 on 05 Jul 2020 22:22:04

RE: PowerView rdlx connecting to on-prem data source

This, and the fact that there needs to be a way to select the text from the table. I dont want to filter on the annoying tiny filter box to the bottom right of the screen. Also, I dont want to export it to excel each time i want to copy something from the table. Please do something about this. It is by far one of the most convinient visualization tools wrt data modelling and presentation. But many features are missing. Looking forward for timely updates.

Douglas Dixon's profile image Profile Picture

09bf9db1 3ce1-4604-84da-8ee47ff67955 on 05 Jul 2020 22:22:02

RE: PowerView rdlx connecting to on-prem data source

This is a show stopper for us too. We can not roll out our dashboard as anticipated without having the ability of the casual user to set a one-time filter that applies to all pages in a dashboard/report.

Douglas Dixon's profile image Profile Picture

179ff44f 07d0-4b0a-9f12-75a76d4215cb on 05 Jul 2020 22:22:02

RE: PowerView rdlx connecting to on-prem data source

That will be soooooo good Lorey, please do it :)

Douglas Dixon's profile image Profile Picture

0e53981d e86e-4344-ae87-1aafca00fe8a on 05 Jul 2020 22:21:54

RE: PowerView rdlx connecting to on-prem data source

You have got to be kidding me. I have been rapid prototyping example dashboards for my organisation. Without this ability I will not be able to recommend PowerBI. Everytime Microsoft! Something looks amazingly positive, and then you go and leave out a vital, game changing (basic) feature. (Same with OneDrive, and OneNote).

Merged Idea (1)