Suman Bhagavathula on 10 Jul 2015 05:12:20
I would like to have the ability to change the data source connection string from the PBI service. Let's say I am playing with a Dashboard and I only want to use my PPE datasource for the connection at this point. Once I am happy with the results and the look and feel, I would need to have the ability to flip the data source to Production before sharing the dashboard with larger audience
Administrator on 07 Dec 2020 21:41:47
There are a couple of ways to achieve this, including Parameters, the REST API and Deployment Pipelines.
- Comments (18)
RE: Ability to change the data source connection string from PBI service
It is essential to be able to swap data connections from test to production.
RE: Ability to change the data source connection string from PBI service
Further, this inability to change connection string means that I can't build a report once locally, then publish to lab, staging, production environments. I would literally have to open the report, change the connection, sync the data local, and manually publish the report for each environment. This has to be fixed ASAP
RE: Ability to change the data source connection string from PBI service
We fully implemented a Power BI Embedded solution on the "old" platform. I would connect to a test database and design a report, publish it to embedded, then update the connection string. This pointed the report datasource at the production data.
With the "new" platform, I would have to connect directly to the production database with Power BI Desktop. This is a near 1TB database, with confidential information in it. This is not a viable enterprise solution. I CAN NOT connect directly to the production database.
As an enterprise platform for embedding, we absolutely need to be able to develop reports on a mock database, then publish the report, then redirect the report to the production data.
RE: Ability to change the data source connection string from PBI service
One of the most important features for those who use PBI service without PBI desktop. Any idea if it's planned?
RE: Ability to change the data source connection string from PBI service
This would be helpful when we have to create report as a template and then share it with users. At the moment this is not possible.
RE: Ability to change the data source connection string from PBI service
Considering that you effectively broke everyone's CRM Online reports sourced via the Service when you upgraded tenants to CRM 2016 and thus changed the OData URL, this would be extremely helpful in not recreating all of the reports from scratch.
RE: Ability to change the data source connection string from PBI service
So many applications: If you are a consultant and have build models based on standard software databases, you can reuse them easily too.
RE: Ability to change the data source connection string from PBI service
This would be really helpful, especially now you've added sharepoint as a datasource we would like to change some of our datesource locations