Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
Good afternoon. I'm trying to create a new Datasource using PHP. When sending a request, an error is returned to me.
Error:
( [error] => Array (
[code] => DM_GWPipeline_UnknownError
[pbi.error] => Array(
[code] => DM_GWPipeline_UnknownError
[parameters] => Array()
[details] => Array(
[0] => Array(
[code] => DM_ErrorDetailNameCode_UnderlyingErrorMessage
[detail] => Array(
[type] => 1
[value] => Неправильный параметр.
)
)
[1] => Array(
[code] => DM_ErrorDetailNameCode_UnderlyingHResult
[detail] => Array(
[type] => 1
[value] => -2146893785
)
)
)
[exceptionCulprit] => 1
)
)
)
PHP:
$gateway = $this->get($gateway_id);
$exponent = $gateway['publicKey']['exponent'];
$modulus = $gateway['publicKey']['modulus'];
$credentialsData = json_encode([
"credentialData" => [
[
"name" => "username",
"value" => $db_username
],
[
"name" => "password",
"value" => $db_password
]
]
]);
$rsa = new RSA();
$rsa->loadKey([
'e' => new BigInteger(base64_decode($exponent), 256),
'n' => new BigInteger(base64_decode($modulus), 256)
]);
echo $rsa->getPublicKey(); // returns -----BEGIN PUBLIC KEY----- ...................... -----END PUBLIC KEY-----
$rsa->setEncryptionMode(RSA::ENCRYPTION_OAEP);
$ciphertext = $rsa->encrypt($credentialsData);
$params = [
"dataSourceType" => $db_type,
"connectionDetails" => json_encode([
"server" => $db_server,
"database" => $db_name
]),
"dataSourceName" => $db_name,
"onPremGatewayRequired" => true,
"credentialDetails" => [
"credentials" => base64_encode($ciphertext),
"credentialType" => "Basic",
"encryptedConnection" => "NotEncrypted",
"privacyLevel" => "None",
"encryptionAlgorithm" => "RSA-OAEP"
]
];
$this->request->execute('gateways/'.$gateway_id.'/datasources', $params, PowerBiRequest::METHOD_POST_JSON);
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
| User | Count |
|---|---|
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 1 |
| User | Count |
|---|---|
| 6 | |
| 5 | |
| 4 | |
| 4 | |
| 3 |