Forum Discussion

martin-z's avatar
martin-z
Frequent Visitor
7 years ago

ODBC connector - Credential connection string properties

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.

Desktop

Portal

 

Need Help

2 Replies

  • martin-z's avatar
    martin-z
    Frequent Visitor
    7 years ago

    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's avatar
      v-juanli-msft
      Community Support
      7 years ago

      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.