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)

039ae511 540b-45d5-b3d6-553225696713 on 05 Jul 2020 23:45:24

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

'@ChrisFinlan beyond sucky... what would need to happen for this feature to be reconsidered?

51320cba d0e3-4394-9278-bdd04c878d2c on 05 Jul 2020 23:45:23

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

Dear Power BI Report Server Team,

I believe this feature is very important for any big organisations who are currently embracing DevOps solution and have multi environments (DEV, UAT,PROD) to consider during deployment.

We have tried all type of work around including unzip/rezip the pbix file in current deployment pipeline, but the result is not good.

The earlier you can implement this feature, the less hassles for large organisations who already chose Power BI as the official BI tool.

Regards,

cd165ccf 27ef-418c-944c-7ab879cc7649 on 05 Jul 2020 23:44:17

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

Is there any new information that can be shared on this? This is needed for us so that we can reduce the amount of time to move reports from one server to another in the reporting life cycle.

6b5da290 c658-49d4-ad07-479db5bd689a on 05 Jul 2020 23:42:30

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

Is there any update on this. Is it possible to create one report and run it for multiple databases by changing the connection string using direct query with OnPremises power bi server?

8e38f801 7823-473d-9ad9-44cae635870f on 05 Jul 2020 23:42:05

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

it seems that Ricardo moved to Google and no-one is following on the request.

b503180b a6b4-4e7a-a219-aa60e4d67a1a on 05 Jul 2020 23:41:40

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

Hoping for news

dcd3d128 d26d-46af-bb0c-30bf8f9533ef on 05 Jul 2020 23:41:39

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

Any news?

7288724e 1c24-42b0-93fb-d5da7ef64694 on 05 Jul 2020 23:41:39

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

add please - all of our datasources will be on prem

6d31b373 f5f4-4beb-9e03-fab08af47180 on 05 Jul 2020 23:41:12

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

Vote !!

edcd1f7e a6f6-4522-82aa-ca4257853f84 on 05 Jul 2020 23:41:12

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

This is an absolute must have & will make managing reports a breeze!