Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Problem in Update Datasource Power BI REST API Call

https://learn.microsoft.com/en-us/rest/api/power-bi/gateways/update-datasource The Power BI REST API call mentioned above is a PATCH request that is used to change/update the datasource credentials....
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hey Anonymous did you try to use the following format?

 

 "credentials": "{\"credentialData\":[{\"name\":\"username\", \"value\":\"john\"},{\"name\":\"password\", \"value\":\"*****\"}]}"

 

Let me know if this works:)  

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Anonymous 

    I tried your format. It is not working. Gave an PrimitiveValue error. Then I tried the same format within curly brackets and I get the following error.

    {
  "error": {
    "code": "BadRequest",
    "message": "Bad Request",
    "details": [
      {
        "message": "The property 'credentials' does not exist on type 'Microsoft.PowerBI.ServiceContracts.Api.GatewayDatasource'. Make sure to only use property names that are defined by the type.",
        "target": "datasourceDelta"
      }
    ]
  }
}

     

     

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Anonymous  Yes I did. I tried various combinations too, it didn't work. But I learnt that we have to encrypt the Windows Username and password into a single string and use that as credential. So I am now trying to find the way to do that encryption in Python. (I made a new question)