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
Just went through my annual password resets. This was fun considering we had to open every PowerBI report and do them one at a time! I submitted this almost a year ago and no movement.
RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server
Having used the Power BI Service in other organisations, to publish a PBIX containing data, then creating reports using that "Power BI Dataset" is great.
Why could that functionality not be made available in PBIRS? Security restrictions do not allow us to use the Power BI Service.
RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server
As I understand there will never be shared data sources for Power BI reports, it will only work for paginated reports. It's a big weakness to consider when comparing to Tableau and Qlik. At least It would have been great to have predefined datasources that could be downloaded from the server.
RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server
Thanks for the response Chris - I'd be happy if that response was an April fools joke, but sadly I don't think it is :-(.
RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server
CNames can help in this situation since MS isn't willing to added existing features. Your network admins can help create CNames to point to servers so if the server changes in the future you can just repoint CName.
RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server
'@ChrisFinlan
The suggested API solution doesn't work well within an enterprise environment.
We have common Power BI prod & dev environments shared between multiple business streams (1 level above departments). As a "content manager" for 1 business stream, I don't have the access to programmatically access the Power BI prod or dev environments, because the information content (dashboards containing data cache) is not supposed to be shared between business streams. The responsibility of developing programmatic access falls back to Power BI admins, who often have other priorities. So, the suggested API approach is not empowering the "content managers".
Would you please reconsider the requested feature?
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?
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,
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.
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?