Frequent Visitor
Posts: 5
Registered: ‎08-13-2017

Power BI Gateway Fails when adding SSL data source

Anyone had the below issues when adding an impala connection(SSL) to the Power BI Gateway?  I added the cert to the trusted certs repo and have tested that the cert works connecting from Excel.  The below error is what I get when adding the data source to the gateway using the service.  This is an Impala connection.  Any feedback is appreciated.


Power BI

Unable to connect: We encountered an error while trying to connect to Details: ""Hide details
Activity ID:d90c4326-cc43-4114-8379-99b8dc0c652b
Request ID:3f0756d7-7cec-0f54-bafd-88fad0283633
Cluster URI:
Status code:400
Error Code:DMTS_PublishDatasourceToClusterErrorCode
Time:Mon Nov 27 2017 15:07:19 GMT+0000 (Coordinated Universal Time)


Received error payload from gateway service with ID 466459: Mashup expression evaluation error. Reason: ..
From Power BI Desktop I get the following error:
Details: "ODBC: ERROR [08S01] [Microsoft][ImpalaODBC] (100) Error from the Impala Thrift API: SASL(-1): generic failure: Failed to initialize security context: The specified target is unknown or unreachable
Posts: 1,386
Registered: ‎03-06-2016

Re: Power BI Gateway Fails when adding SSL data source



Did you configue the services of Power BI gateway? After installing gateway it has it's own service account which may do not have the access to ODBC driver. You could change the service account to your Window account and check if this issue persists or not.



Charlie Liao