Ability to change the data source connection string from PBI service

[#1]

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

[jan]

This would be really helpful, especially now you've added sharepoint as a datasource we would like to change some of our datesource locations

[pilz]

So many applications: If you are a consultant and have build models based on standard software databases, you can reuse them easily too.

[fbcideas_migusr]

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.

[aishkarthik]

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.

[trevorgermain]

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.

[trevorgermain]

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

[alexandre_tanne]

One of the most important features for those who use PBI service without PBI desktop. Any idea if it's planned?

[davidi_brown]

It is essential to be able to swap data connections from test to production.

[masabogal]

It is essential, we absolutely need to be able to change data connections between environments.

[sravank194]

Hi, anyone help on above mentioned query.