topic PBI Rest API : Datasets - Update Datasources In Group (PowerBIEntityFrameworkOperationException) in Developer

PBI Rest API : Datasets - Update Datasources In Group (PowerBIEntityFrameworkOperationException)

Anonymous — Mon, 29 Mar 2021 18:32:43 GMT

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.

Re: PBI Rest API : Datasets - Update Datasources In Group (PowerBIEntityFrameworkOperationException)

lbendlin — Wed, 31 Mar 2021 01:07:33 GMT

Are you currently the dataset owner or did someone else take it over?

Re: PBI Rest API : Datasets - Update Datasources In Group (PowerBIEntityFrameworkOperationException)

Anonymous — Wed, 31 Mar 2021 08:27:17 GMT

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.

Re: PBI Rest API : Datasets - Update Datasources In Group (PowerBIEntityFrameworkOperationException)

lbendlin — Wed, 31 Mar 2021 11:59:15 GMT

Do you get the same error message in the sandbox?

Re: PBI Rest API : Datasets - Update Datasources In Group (PowerBIEntityFrameworkOperationException)

Anonymous — Wed, 31 Mar 2021 12:00:11 GMT

Yes 😞