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 (87)
RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server
'@Riccardo - could you please provide an update on shared/server-based connections for PBI?
RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server
Ideally not just have shared data sources only for PowerBI but be able to share the same data sources across SSRS and Power BI reports.
RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server
This should be basic functionality. Not having it is absurd.
RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server
This is an enormously painful missing feature, for test to prod deploys, for SSAS server migrations, it makes something that should be minutes turn into a huge project.
It makes things like upgrading to a new version of SSAS much more painful
RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server
SSRS already supports Shared Data Sources (and has done for a long time), it would be good if PBIRS could either use the existing SSRS Data Sources, or have an equivalent for PowerBI. Having the data source embedded within each PBI report is not ideal, as others have commented.
RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server
Not having a shared data source is breaking our deployment model based on SSRS. We are typically able to set up the same data source on dev and production and then copy the report from dev to prod without changes by the admin. Now we have to open the report with designer and modify it since we cannot even change the server name through the report manager web interface. Hope to see this soon. Thanks!
RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server
Here is a cross post as this issue has been raised in other forum as well https://feedback.azure.com/forums/556165-azure-analysis-services/suggestions/17173610-built-in-ssrs-support-for-azure-as
This a big roll-out blocker for Power BI Report Server paginated reports which cannot not connect to Azure AS. Having Power Query connectors as shared data sources in Power BI Reports server would be a dream !
RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server
This is a must in my opinion, for house keeping and trouble shooting.
I am surprised that it has not been done yet.
RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server
This is a basic requirement for us, and is blocking migration to PowerBI
RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server
Any new on this?