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

[patrick_purvia1]

2.5 years and no response from MS? Has this somehow been solved and no one thought to update this Idea or share it in Google-able way??

[juha_helminen]

Yes!

[estoll]

I agree with all the comments here. This would be incredibly helpful.

[john_fuhrman1]

you can actually do this using the REST API's within Power BI... you'll need the workspace ID (Group), the Report ID, the Dataset ID, then some connection information. You'll issue a POST http message, see this: https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/updatedatasourcesingroup#code-try-0 but if you pass the correct arguments you can change the binding of the datasets/datasources as desired. feel free to contact me for more info on these. they're pretty handy to use.

[hans_bellen]

We can update connection string of OData URLs within datasources that are independent. However REST APIs do not support updating connection string URL for datasources which are part of merged or joined tables Also REST API do not have support for creating tiles within Dashboard correctly yet. Hopefully those APIs improve!

[nishalit]

There are a couple of ways to achieve this, including Parameters, the REST API and Deployment Pipelines.

[alexander_brant]

Parameters are not allowed if connected to a TabularModel in DQ Mode... so this is not a viable solution for this (really common!!) problem. How would MS have us deploy our pbix to a production environment where developers usually have no permissions? In all other reporting tools (those I know, including SSRS .rdl files) this is a pretty simple task as it should be!

[kmowrey1]

This is still needed to help prevent unwanted ad-hoc connections from sources like Excel. Please fix. 

[alexander_georg]

Would also really wish for this feature...

Just allows reusage of dashboards.