ODBC connector - Credential connection string properties

[martin-z]

I'm connecting to a data source via the odbc connector. I have to specify additional properties to the field "Credential connection string properties (optional)" in Power BI Desktop to be able to connect to that data source. I can't see the same field in the Power BI service portal when adding data source to the gateway. Please help.

[martin-z]

Hi, I'm trying to connect to the Impala via Power BI Desktop Impala connector. I'm getting an error: "ODBC: ERROR [HY000] [Micosoft][DriverSupport] (1100) SSL certificate verification failed because the certificate is missing or incorrect." I'm getting the same error from the gateway. I don't know where to install the certificate or where to specify path to the certificate. Please help.

[v-juanli-msft]

Hi @martin-z 

Please update your Power BI Desktop to latest version

Ensure that the SSL protocol version is lower than TLS 1.2

Reference:

Configuring TLS/SSL for Impala

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.