Power BI Cloudera Impala connection

Hi Guys,

 I'm trying out the impala connector. One caveat with the current implementation is that it does not support SSL & certificates. I'm getting the error at the end of this message. In order to connect to impala at my company, we need to use a certificate file (i.e. an .PEM file). The current connector lacks this capability.

On the other hand, connecting by using cloudera's ODBC driver for impala does work, since it let's you specify the certificate file , although it seems to lack support for Direct Queries I can live with Import option for now, But the real problem for me is scheduling refresh via on premieses gateway, I have succuesfully configured gateway in my reporting server, Now I am trying to ADD DATA SOURCE and I get the below error message, I have contacted Microsoft but they say since it is "HY" error it is a problem with the driver, but with the same user name , Password, host etc details(which I cross checked unlimited times) I could connect to the database and even manually reload the data,But I am facing real problem when trying to schedule it.

FYI

All the required ports have been opened, connection details are the same, evrything is the same

Error message 
ODBC: ERROR [HY000] [Cloudera][ImpalaODBC] (100) Error from the Impala Thrift API: SSL_CTX_load_verify_locations: Input/output error; system lib; system lib ERROR [HY000] [Cloudera][ImpalaODBC] (100) Error from the Impala Thrift API: SSL_CTX_load_verify_locations: Input/output error; system lib; system lib