Can the Rest API change the connection string (username/password) of a published dataset?

[Anonymous]

I know I can do it in PBI Desktop.  But that's no help to me.  The API claims to be able to update connections...

https://msdn.microsoft.com/en-us/library/mt748181.aspx

but I can't get it to work at all.  Keep getting '400 Bad Request'.  I'm starting to think the API doesn't work too well.

[ankitpatira]

@Anonymous Fact that there is MSDN article on it means it is certainly possible. You just need to troubleshoot the error you're getting.

[Anonymous]

I've tried everything.  I keep getting a 400 Bad Request error.

MSDN states the url is:

https://api.powerbi.com/v1.0/myorg/myorg/datasets/{dataset_id}/Default.SetAllConnections

I assume the /myorg/myorg is a typo.  Otherwise I get a 404 error.

I'm passing in the exact json in the MSDN article.  And using the PostRequest sample code provided by microsoft.  However, it's interesting that the sample code I got from MSDN does not include a call to SetAllConnections...

https://msdn.microsoft.com/en-us/library/mt186159.aspx

Can anyone actually confirm this API call works?

[Anonymous · Accepted solution]

Finally worked it out - it's not possible.

For some reason, the Rest API is documented twice.  Once on msdn and once here...

http://docs.powerbi.apiary.io/#reference/datasets/update-all-connection-strings/update-all-connectio...

And you can see on the apiary page that SetAllConnections only works on direct query connections.

[Anonymous]

We need to change connection strings for Tabular model/ SAAS and its not possible through this API because its not a direct query.

Is there any otjer way to do this?

[Anonymous]

It sure looks like it should be possible.  However I can't get it to work.

Basically I'm doing an HTTP POST to:

https://api.powerbi.com/v1.0/myorg/datasets/9e396f95-f576-4dc0-adf7-967612e25a46/Default.SetAllConne...

with a body of:

{"connectionString":"data source=xxx.database.windows.net;initial catalog=ElasticDBQuery;user id=xxx;password=xxx;"}

I've tried lots of things but I always get:

The remote server returned an error: (400) Bad Request.