topic PBI Rest API - Create datasource in gateway error in Developer

PBI Rest API - Create datasource in gateway error

Angel — Wed, 01 Jul 2020 10:32:53 GMT

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,

Re: PBI Rest API - Create datasource in gateway error

lbendlin — Wed, 01 Jul 2020 20:29:18 GMT

Doesn't look like your credentials are OAEP padded.

Re: PBI Rest API - Create datasource in gateway error

Angel — Thu, 02 Jul 2020 09:37:27 GMT

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,

Re: PBI Rest API - Create datasource in gateway error

Anonymous — Thu, 12 Nov 2020 16:06:20 GMT

Any update here?

How to do encryption in Power Shell or how to skip credential details and just add the datasource?

Re: PBI Rest API - Create datasource in gateway error

vpartem — Wed, 18 Nov 2020 20:10:02 GMT

i have the same problem. Anyone?

Re: PBI Rest API - Create datasource in gateway error

ed-freeman — Fri, 04 Dec 2020 14:31:00 GMT

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,