Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
}
}
}
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.
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
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.
User | Count |
---|---|
45 | |
26 | |
21 | |
18 | |
18 |
User | Count |
---|---|
53 | |
45 | |
25 | |
24 | |
21 |