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.
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,
Solved! Go to Solution.
Doesn't look like your credentials are OAEP padded.
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
Any update here?
How to do encryption in Power Shell or how to skip credential details and just add the datasource?
i have the same problem. Anyone?
Doesn't look like your credentials are OAEP padded.
Hi @lbendlin
I think you are right. I have found documentation that explains how to encrypt credentials in C#.
Do you know if there is a cmdlet in Powershell to do that?.
Thanks,
User | Count |
---|---|
3 | |
2 | |
2 | |
2 | |
1 |