Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi folks,
I'm calling the endpoint described here https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/updatedatasourcesingroup in bid to reconfigure my Analysis Services data source. My Analysis Services instance resides on-premise thus is delivered via a Gateway Cluster and Dataset.
The HTTP POST Body is roughly the following:
{
"updateDetails": [
{
"datasourceSelector": {
"datasourceId": "Datasource GUID HERE",
"connectionDetails": {
"database": "CURRENT_CUBE_NAME",
"server": "CURRENT_CUBE_SERVER"
},
"datasourceType": "AnalysisServices",
"gatewayId": "Gateway GUID HERE"
},
"connectionDetails": {
"database": "NEW_CUBE_NAME",
"server": "NEW_CUBE_SERVER"
}
}
]
}
Sadly the request constantly throws the below HTTP 400 Bad Request error:
"error":{"code":"PowerBIEntityFrameworkOperationException","pbi.error":{"code":"PowerBIEntityFrameworkOperationException","parameters":{},"details":[]}}}
Interestingly, this was all working up until a few months ago.
Any help would be appreciated.
Many Thanks,
Tim.
Do you get the same error message in the sandbox?
Yes 😞
Are you currently the dataset owner or did someone else take it over?
I am the dataset owner. I explicitly take ownership with this call https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/takeoveringroup before attempting to update the data source.
User | Count |
---|---|
16 | |
5 | |
2 | |
1 | |
1 |
User | Count |
---|---|
22 | |
3 | |
3 | |
2 | |
1 |