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

Louise Moore on 30 Oct 2023 22:51:34

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

Please reconsider. This feature is a must have IMHO.

Harsha's profile image Profile Picture

John Silverwood on 20 Oct 2023 16:36:47

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

This makes zero sense that a feature that was available with SSRS is now not available in the next generation (PowerBI report server). This probably affects hundreds of customers paying quite a lot of money for features promised with SQL Server Enterprise...

Harsha's profile image Profile Picture

Scott C. Conrad on 06 Jan 2023 16:43:13

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

I hope the development team reconsiders this item. The api to update the passwords helps (we are in a high security environment so all accounts must have new passwords monthly) however when multiple dashboards utilize the same data source it places undue load on the source systems because each individual dashboard must refresh the internal dataset independently when they could all be using a shared data set.

Harsha's profile image Profile Picture

AC ZH on 25 Jul 2022 21:21:25

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

This feature is really needed from our company, please reconsider it.

Harsha's profile image Profile Picture

Perry Neal on 06 Dec 2021 17:48:06

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

In highly secure environments these back end passwords change quite frequently. This is a major oversight from the PG. Please reconsider!

Harsha's profile image Profile Picture

Peter Kennedy on 09 Oct 2021 05:43:45

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

Disappointing that this is DECLINED - inability to use Shared Data Sources is a big obvious short-coming for Power BI reports hosted on premises.
"What do you mean it can't connect to a Shared Data Source?!" is a question I've faced multiple times regarding Power BI reports...

Harsha's profile image Profile Picture

N C on 31 Jul 2020 12:18:32

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

It is completely nuts that you cannot have a shared data source on PBI Server. So PBI is now available to far more people under the new licensing agreement and is heralded as a really great feature of SQL Server 2019 ... BUT ... this is a real blocker to migration from SSRS.

Harsha's profile image Profile Picture

M on 06 Jul 2020 00:18:00

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

I just ended up here while looking for a solution on how to use shared data sources in PowerBI on prem server.
We do not allow our Data Analysts access to create Data Sources on our SSRS server. We do this so we can better manage what data sources are used, and aid us in easily making changes in the event of a migration or upgrade, as well as the ability to disable specific data sources easily if the need arises. Not having an ability to use a shared data source severely limits what our Analysts can do.
Providing an API to update an embedded data source is not a solution, but a hacky work around for what I imagine is a feature that was purposefully left out in order to get companies on the Power BI Service. How is this feature not available? Is this something that could be added down the road or are we just supposed to grin and bear it.

Harsha's profile image Profile Picture

Ayman on 06 Jul 2020 00:15:46

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

a shared data source is good idea to be in Power bi, it;s already exist in SSRS

Harsha's profile image Profile Picture

Dan on 06 Jul 2020 00:06:14

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

This is kinda silly that it's standard in SSRS and that it's not on power bi server. Kind of a requirement to give access to report developers at a large company. We have done so many clunky things to get around this issue. ODBC connections and keytabs