Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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?
It sure looks like it should be possible. However I can't get it to work.
Basically I'm doing an HTTP POST to:
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.