Power BI
DeclinedShared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server
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)
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.
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...
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.
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.
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!
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...
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.
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.
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
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