topic Issue while creating data source under Data Gateway using powershell in Developer

Issue while creating data source under Data Gateway using powershell

riyajshaikh09 — Tue, 28 Feb 2023 14:30:13 GMT

I am using powershell for .pbix to deployment in workspaces. As part of that i need to create SQL datasource under gateway for further use. I am using powerbI rest API with service principle : https://learn.microsoft.com/en-us/rest/api/power-bi/gateways/create-datasource

Here is link for sample we can use in powershell: https://community.powerbi.com/t5/Developer/Power-BI-REST-API-via-Powershell-Create-Datasource/m-p/511934

I hope someone can help me here. Thanks in advance.

API I am seding request:
POST https://api.powerbi.com/v1.0/myorg/gateways/{gatewayId}/datasources

Request message Body:

{ "connectionDetails": "{\"server\":\"MyServer\",\"database\":\"MyDatabase\"}", "datasourceName": "Test_dateasource", "dataSourceType": "Sql", "credentialDetails": { "credentialType": "Basic", "encryptedConnection": "Encrypted", "encryptionAlgorithm": "RSA-OAEP", "privacyLevel": "Organizational", "credentials": "W3....==" } }

Response from API:

{ "error": { "code": "DM_GWPipeline_UnknownError", "pbi.error": { "code": "DM_GWPipeline_UnknownError", "parameters": {}, "details": [ { "code": "DM_ErrorDetailNameCode_UnderlyingErrorMessage", "detail": { "type": 1, "value": "The parameter is incorrect.\r\n" } }, { "code": "DM_ErrorDetailNameCode_UnderlyingHResult", "detail": { "type": 1, "value": "-2146893785" } } ], "exceptionCulprit": 1 } } }

Re: Issue while creating data source under Data Gateway using powershell

lbendlin — Mon, 06 Mar 2023 02:34:55 GMT

Assuming you have a Pro license you can consider raising a Pro ticket at https://powerbi.microsoft.com/en-us/support/pro/

Re: Issue while creating data source under Data Gateway using powershell

PierreHusted — Mon, 13 Mar 2023 10:41:45 GMT

I've got the same problem.
Just gonna keep an eye here, in case you figure it out.

Re: Issue while creating data source under Data Gateway using powershell

riyajshaikh09 — Tue, 14 Mar 2023 13:36:51 GMT

I am able to solve this problem, In my case credential encryption was not correct. using owershell i was not able to encrypt credentials correctly.
To solve this i used C# code from below sample to encrypt credentials. So I created C# console application and use that .exe to encrypt credentials.
https://github.com/microsoft/PowerBI-Developer-Samples/tree/master/.NET%20Core/EncryptCredentials