Forum Discussion
Angel
6 years agoResolver III
PBI Rest API - Create datasource in gateway error
Hi, everyone
I hope someone can help me. I'm trying to create a datasource in a gateway using PBI Rest API and it shows an error. The body I'm using is the one that is in documentation.
Body
{
"dataSourceType": "SQL",
"connectionDetails": "{\"server\":\"MyServer\",\"database\":\"MyDatabase\"}",
"datasourceName": "Sample Datasource",
"credentialDetails": {
"credentialType": "Windows",
"credentials": "AB....EF==",
"encryptedConnection": "Encrypted",
"encryptionAlgorithm": "RSA-OAEP",
"privacyLevel": "None"
}
}Response
{
"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, 10"
}
},
{
"code": "DM_ErrorDetailNameCode_UnderlyingHResult",
"detail": {
"type": 1,
"value": "-2146233296"
}
}
],
"exceptionCulprit": 1
}
}
}
Any tip?...
Thanks in advance,
Doesn't look like your credentials are OAEP padded.
5 Replies
- lbendlinSuper User
Doesn't look like your credentials are OAEP padded.
- AnonymousNot applicable
Any update here?
How to do encryption in Power Shell or how to skip credential details and just add the datasource?
- vpartemFrequent Visitor
i have the same problem. Anyone?
- ed-freemanAdvocate II
Hi all. Here's how to update on-prem datasource credentials using PowerShell:
How to update credentials for an on-prem Power BI data source using PowerShell
Hope this helps,
Ed