Member since
07-13-2017
5
Posts
1
Kudos Received
0
Solutions
07-14-2017
09:22 AM
1 Kudo
I have made it work finally, The issue is with PBI, After installing gateway it has it's own service account from which it connects to the driver which doesn't have access to so it's failing, I need to change the service account to windows service account with which I logged in service seetings in On premises Gateway (Power BI) and it worked Thanks a lot for your time Cheers
... View more
07-14-2017
04:25 AM
I have set up Power bI gateway in the same machine in which I configured ODBC details, also in that DSN did you enable SSL and set the PEM file location? Did you upload the PEM cert to that location on that host? Yes I did that, as said when I try to connect to Power BI directly to the odbc it is working only when I install gateway and try scheduling the refresh I get this error, I have configured that in SSL Options --> Trusted Certificates FYI again its working when I connect to PBI Directly, the problem only comes when I try the schedule refresh of data Thanks for your help, Looking forward for your response
... View more
07-13-2017
10:15 AM
Also to add on, as mentioned above when I connect to power bi it is identifying the certificate which we defined the location in SSL options Trusted Certificates
... View more
07-13-2017
10:13 AM
Yes I am using SSL & certificates.In order to connect to impala at my company, we need to use a certificate file (i.e. an .PEM file).
... View more
07-13-2017
05:54 AM
Hi Guys, We are using Power BI as our reporting tool, as PBI is not supporting Kerbores security even though they have direct conncetor to Impala from PBI we have downloaded Cloudera ODBC driver for Impala version 2.5.37.1014 (64 bit) and configured it in system dsn, It is all working if I connect to PBI to this ODBC driver and I can pull all required tables and create my reports on top of it in PBI, Also I can manually refresh data, It's all great till now, But when I try to sechdule dynamic refresh data by installing Power BI gateway on a server and try to give data source details it is throwing me an below error, I have consulted Microsoft guys and they are saying that this is a driver issue since the error is HY****, But i am struggling to understand when it can connect and refresh when I do it manually why the problem with driver when we try to sechdule, Somebody can look into this asap please for me so that I can get back to Microsoft with the update Errro : ***** 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 ***** Please help me on this Thanks Sandeep
... View more
Labels:
- Labels:
-
Apache Impala