Forum Discussion
Problem with Refreshing Dataset after Parameter Change with Service Principal
Your process is missing a step. After a semantic model takeover all data source credentials are removed and need to be reapplied.
Datasets - Update Datasources In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Thanks lbendlin .
After the 'Takeover Dataset' step, I tried the Datasources Update endpoint
with the following request body:
{
'updateDetails': [
{'datasourceSelector':
{
'datasourceType': 'MySql',
'connectionDetails': {
'server': 'demo_server_01',
'database': 'demo_database_01'
}
},
'connectionDetails': {
'server': 'demo_server_01',
'database': 'demo_database_01'
}
}
]
}
But received the following message:
{"error":{"code":"InvalidRequest","message":"The given connection details for selector # are invalid"}}Is there any information in the request body that I need to add or modify?
Did you ever manage to find the solution to this?
Any solution for this?
I raised an MS support ticket which made it through to the PowerBI 3rd line support team.
I was told this API endpoint is not actually designed for updating to a connection that already exists and there is currently no endpoint available for it. Which seems wild to me, it seems like exactly what it's for.
I gave up in the end
I would recommend you raise a DCR.
