Gateways - Update Datasource request fails: Invalid Ciphertext size.

[xli629b]

When I make a request to update datasource for a gateway, I get an error about ciphertext that seems rather confusing since I'm just using Basic credentials. Any idea what this means?

PATCH https://api.powerbi.com/v1.0/myorg/gateways/(my-gateway-id)/datasources/(my-data-set-id)

{
  "credentialDetails": {
    "credentialType": "Basic",
    "credentials": "{\"credentialData\":[{\"name\":\"username\", \"value\":\"my_username\"},{\"name\":\"password\", \"value\":\"my_password\"}]}",
    "encryptedConnection": "NotEncrypted",
    "encryptionAlgorithm": "None",
    "privacyLevel": "None"
  }
}

{
  "error": {
    "code": "DM_GWPipeline_UnknownError",
    "pbi.error": {
      "code": "DM_GWPipeline_UnknownError",
      "parameters": {},
      "details": [
        {
          "code": "DM_ErrorDetailNameCode_UnderlyingErrorMessage",
          "detail": {
            "type": 1,
            "value": "Invalid Ciphertext size. Expecting cipher text of atleast length, 344. Provided cipherText length, 93"
          }
        },
        {
          "code": "DM_ErrorDetailNameCode_UnderlyingHResult",
          "detail": {
            "type": 1,
            "value": "-2146233296"
          }
        }
      ],
      "exceptionCulprit": 1
    }
  }
}

[afernand0]

I'm getting the same error when trying to update basic credentials. Much appreciated if anyone can shed some light on to what's causing this error. Thanks.

[Icey]

Hi @xli629b ,

Is this problem solved?

If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If not, please let me know.

Best Regards
Icey

[Icey]

Hi @xli629b ,

I suggest you to refer to this post first to create a database without database name by using RESTful API: https://community.powerbi.com/t5/Power-Query/Gateway-advises-Sql-Database-function-is-unsupported/m-....

Then, try this:

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.