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
- fxs7576_021 year agoHelper I
Thanks lbendlin .
After the 'Takeover Dataset' step, I tried the Datasources Update endpointwith 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?
- LJonesStripe1 year agoRegular Visitor
Did you ever manage to find the solution to this?
- jbauti101 year agoAdvocate I
Any solution for this?
- LJonesStripe1 year agoRegular Visitor
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