Skip to main content

Power BI

Declined

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

Vote (452) 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 (93)
Harsha's profile image Profile Picture

John Pratt on 05 Jul 2020 23:00:08

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

I have just implemented PBIRS Aug 2017 Preview along with the Desktop RS (June 2017) app. I have a PBIX with live query against an SSAS cube data source. My report security on the server and against SSAS is set up to use a tunnel account, which means specifying specific credentials for the report to run as at runtime. The current desktop app for RS does not allow specifying a shared data source OR specifying credentials. Every time I deploy a change to the report (Save As to the report server), the server-side report's embedded data source settings are overwritten. Once I have both TEST and PROD set up with PBIRS, this will be a very brittle and time-consuming situation as I will have to update the data source settings with every deployment no matter how small the change was.

PLEASE add support for both shared data sources for PBIX reports under report server and specifying the data source and/or credentials in the desktop RS app as a priority. This should work just like SSRS report development using Visual Studio, with an IDE connection, a published shared data source which is not overwritten with each report deployment, and the ability to create and use a shared data source on the server.

Harsha's profile image Profile Picture

Paul Clark on 05 Jul 2020 22:58:10

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

This would allow for easy management and updating of data sources without causing a downtime for our customers

Harsha's profile image Profile Picture

Mark Stacey on 05 Jul 2020 22:56:43

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