Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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,
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
3 | |
3 | |
3 | |
2 | |
2 |