Forum Discussion
CredentialMissing when trying to add MariaDB datasource to Gateway
I have registered an on-premises data gateway on our PowerBI Service account.
I was then trying to add a new datasource to it, for the time being using Postman, with the aim to fully automate it via powershell:
POST https://api.powerbi.com/v1.0/myorg/gateways/13ba33f6-42e7-4b75-abdf-cd81fafe18f4/datasources
with body
{
"datasourceName": "common.powerbi.626suite-online.it",
"connectionDetails": "{\"extensionDataSourcePath\": \"{\\\"MariaDB Data Source\\\": \\\"common.powerbi.626suite-online.it\\\"}\",\"extensionDataSourceKind\": \"MariaDB\"}",
"credentialDetails": {
"useCallerAADIdentity": false,
"privacyLevel": "Organizational",
"encryptionAlgorithm": "RSA-OAEP",
"credentialType": "Basic",
"useEndUserOAuth2Credentials": false,
"encryptedConnection": "Encrypted",
"credentials": "tqM[...]XpA=="
},
"dataSourceType": "Extension"
}
This API call fails with an error stating that "Credentials are required to connect to the MariaDB source", however the credentials are clearly present in the request...
I have checked that
- the gateway can correctly connect to the datasource from the command line
- the credentials are (or at least seem to be) correcty encrypted with the gateway public key, as shown in some tutorials like https://endjin.com/blog/2020/12/how-to-update-credentials-for-an-on-prem-power-bi-data-source-using-powershell and https://community.powerbi.com/t5/Developer/encrypt-credentials-to-create-datasource-PowerShell/m-p/3186355/highlight/true#M42177
- the custom connector for MariaDB is correctly loaded
Can anyone help me understand why am I getting this error?
No RepliesBe the first to reply