Skip to main content

Power BI

Declined

Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server

Vote (435) Share
Harsha's profile image

Harsha on 03 Jul 2017 11:21:18

Currently each Power BI report published to the Report Server has its own data source embedded within the report. Any change in the source would require us to change hundreds of published reports individually. Could we have a shared data source/connection similar to SSRS Reports that would help us manage deployment and changes much more efficiently.

Administrator on 01 Apr 2019 23:38:54

We're not planning to make this feature available in Power BI Report Server. We are looking at making available an API to allow you to change the data source programatically, however, to make movement between servers easier.

Comments (87)
Harsha's profile image Profile Picture

83952f3d 824a-4b04-9ce8-991b35371a34 on 05 Jul 2020 23:19:16

RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server

Please consider this for the next release of PBIRS . ASAP

Harsha's profile image Profile Picture

759e9c5a d685-4d08-b6f0-06ecef1a9204 on 05 Jul 2020 23:19:04

RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server

definitely needed

Harsha's profile image Profile Picture

e5147a26 d9d6-45a3-9ecc-ef5a1313dbed on 05 Jul 2020 23:18:33

RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server

I see that this has been under review for over 9 months, is there an update?
Would this functionality be forth coming?
Very interested to see this working and then it would be enterprise ready.

Harsha's profile image Profile Picture

0377af90 2922-4dcb-a60a-609d9794688b on 05 Jul 2020 23:17:54

RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server

Super surprised that this feature was lost from SSRS to PowerBI Report Server. This is a must in order for us to proceed with moving to a production implementation. Please implement ASAP.

Harsha's profile image Profile Picture

86fa0962 07ac-410a-a97b-e3f522f2fecc on 05 Jul 2020 23:17:52

RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server

Please add this feature so that it is much easier to manage connections for the reports.

Harsha's profile image Profile Picture

22f4900d 0c5a-4baf-bb36-91fb8eb360b9 on 05 Jul 2020 23:17:28

RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server

Major oversight leaving this ability out. Please implement ASAP.

Harsha's profile image Profile Picture

ba2ac790 c9d0-469c-9398-e900b9b491d6 on 05 Jul 2020 23:16:56

RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server

This was something available, and usable in SSRS all the way back to SQL-2000. I would think that not having shared datasources for on-prem power BI reporting server makes it a NON starter and makes me wonder if the old Chrystal Reports is a better product; Or is there an Open Source alternative

Harsha's profile image Profile Picture

d2c39893 48fe-4151-91ba-318d595f14fd on 05 Jul 2020 23:16:55

RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server

This is a much needed feature so we can manage all the sources at one place and also used one source for multiple reports. Easy to maintain for password changes? or if we have to point all reports to a different server one place shot!

Harsha's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:14:51

RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server


Please consider this for the next release of PBIRS.

Harsha's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:14:32

RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server

Deployment is currently error-prone and time consuming, having to change the DS for every single report, one at a time. At least if the DataSource table could be in plain text we could at script DS changes more easily.