API - Update Datasources not changing report data

Anonymous — Tue, 11 Aug 2020 16:09:20 GMT

Hi,

I'm trying to use the "Datasets - Update Datasources In Group" API endpoint to remap the datasources of reports hosted on the Power BI server between different SQL Server databases. I submit the following JSON as part of the call:

json_content = {
"updateDetails": [
{

"datasourceSelector": {
              "datasourceType": "Sql",
              "connectionDetails": {
                  "server": "<current server>",
                  "database": "<current DB>"
                  }
              },
          "connectionDetails": {
              "server": "<target server>",
              "database": "<target DB>"
              },
          "datasourceId": "<target_datasource_ID>",
          "datasourceType": "Sql",
          "gatewayId": "<target_gateway_ID>"
          }
      ]
  }

and when I check the datasource via the "Datasets - Get Datasources In Group" it seems to have remapped successfully. However, this doesn't seem to be reflected in the report data. I have tried refreshing the report both manually in the server UI and via the dataset refresh API endpoint. Is there something I'm missing in getting the datasource update to carry through to the report data?
Thanks

topic API - Update Datasources not changing report data in Report Server

API - Update Datasources not changing report data