Power BI
Needs VotesAbility to change the data source connection string from PBI service
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
- Comments (15)
RE: Ability to change the data source connection string from PBI service
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!
RE: Ability to change the data source connection string from PBI service
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.
RE: Ability to change the data source connection string from PBI service
I agree with all the comments here. This would be incredibly helpful.
RE: Ability to change the data source connection string from PBI service
Yes!
RE: Ability to change the data source connection string from PBI service
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??
RE: Ability to change the data source connection string from PBI service
Hi, anyone help on above mentioned query.
RE: Ability to change the data source connection string from PBI service
It is essential, we absolutely need to be able to change data connections between environments.
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.