Forum Discussion
Can the Rest API change the connection string (username/password) of a published dataset?
Finally worked it out - it's not possible.
For some reason, the Rest API is documented twice. Once on msdn and once here...
And you can see on the apiary page that SetAllConnections only works on direct query connections.
Anonymous Fact that there is MSDN article on it means it is certainly possible. You just need to troubleshoot the error you're getting.
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?
Finally worked it out - it's not possible.
For some reason, the Rest API is documented twice. Once on msdn and once here...
And you can see on the apiary page that SetAllConnections only works on direct query connections.
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?