Has anyone successfully use the REST API to update a Power BI data source from one Databricks cluster to another?
My json for the datasourceSelector is a copy and paste of the get datasources end point but it the REST API for update datasources (groups/guid/datasets/guid/Default.UpdateDatasources) still can't find it. I've tried this in postman and in powershell. I've tried different variations of the path with and without quotes and escapes and with extra escapes and with the path as a collection of the host and httpPath... Nothing seems to work. Thoughts?
{
"UpdateDetails": [
{
"datasourceSelector": {
"datasourceType": "Extension",
"connectionDetails": {
"path": "{\"host\":\"adb-databricks.10.azuredatabricks.net\",\"httpPath\":\"sql\/protocolv1\/o\/databricks\/4444-555555-n1m2o3\"}",
},
"datasourceId": "<<guid>>",
"gatewayId": "<<another guid>>"
},
"connectionDetails": {
"datasourceType": "Extension",
"connectionDetails": {
"path": "{\"host\":\"imatest.10.azuredatabricks.net\",\"httpPath\":\"sql\/protocolv1\/o\/imatest\/0a0a-155240-n0d8a4u\"}",
"kind": "Databricks"
},
"datasourceId": "<<guid>>",
"gatewayId": "<<another guid>>"
}
}
]
}
