Power BI

Declined

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

Vote (435)

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)

Comments (87)

5dc73e51 814d-4da8-9281-2510914a76bb on 05 Jul 2020 23:27:41

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

wondering why it takes so long for MS to include it.

40e26cd4 70b9-4fec-9d51-1668ea28fccc on 05 Jul 2020 23:27:17

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

Having shared datasources for SSRS has made our over a thousand reports manageable so yes indeed we would like to be able to share any power bi data source the same way

bbb0289d cd02-470f-9ccc-bf8f1dbab12c on 05 Jul 2020 23:26:48

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

This is one of the two reasons currently stopped us to deploy power bi report service.

ba39f61f 954e-4283-85da-44996c86a921 on 05 Jul 2020 23:26:38

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

Having shared datasources for SSRS has made our over a thousand reports manageable so yes indeed we would like to be able to share any power bi data source the same way.

b347e51a b937-42f4-bd9e-e68613fbb976 on 05 Jul 2020 23:26:36

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

Yes please! We really need this to manage our data sources.

9c814445 f36e-4a7a-a923-7e1042cca9bc on 05 Jul 2020 23:26:36

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

This is critica functionality for an enterprise on-premis deployment.

6ed2d9eb 5510-4088-86cf-e24fe4600bc8 on 05 Jul 2020 23:25:19

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

Much required functionality....

45784d15 7761-4951-b261-4d77222224de on 05 Jul 2020 23:24:59

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

we definitely need this and should be out of the box. If we do allow business to deploy their report, we need them to own the report layer and not the data. Dataset and data sources are more govern and made available on the server as Shared Data Set and Data Source!

7f4fcc20 d0f5-4d7f-bc2c-63293c5494a6 on 05 Jul 2020 23:24:00

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

Agree with other comments on this post. This would greatly simplify management and deployment.

2683d581 688b-4acb-a022-4abe0ec9d667 on 05 Jul 2020 23:23:31

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

This shared data sources is a huge deal for us - it will simplify deployment and management immensely