Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Gateway - Unable to add Impala data source

Submitted by Anonymous on ‎09-20-2017 03:51 AM

Hi,

I m trying to add an Impala Data Source, I m seeing the error below.

 

Unable to connect: We encountered an error while trying to connect to 10.12.65.6:21050. Details: "Cannot connect to the mashup data source. See error details for more information."Hide details

Activity ID:3572add4-fc15-4ce7-8e6a-c97215e7b4e7
Request ID:fd91b658-39cf-89ba-5349-d55937e6a3dd
Cluster URI:https://wabi-north-europe-redirect.analysis.windows.net
Status code:400
Error Code:DM_GWPipeline_Gateway_MashupDataAccessError
Time:Wed Sep 20 2017 15:23:49 GMT+0530 (India Standard Time)
Version:13.0.2436.220
Underlying error code:-2147467259
Underlying error message:ODBC: ERROR [08S01] [Microsoft][ImpalaODBC] (100) Error from the Impala Thrift API: connect() failed: errno = 10060
DM_ErrorDetailNameCode_UnderlyingHResult:-2147467259
Microsoft.Data.Mashup.ValueError.DataSourceKind:Impala
Microsoft.Data.Mashup.ValueError.DataSourcePath:10.12.65.6:21050
Microsoft.Data.Mashup.ValueError.Reason:DataSource.Error

 

 

PBI_Error.png

 

 

However, I have already added another Impala data sorce as shown in the snapshot.

The only difference wrt the new Impala data source is that it is hosted on an Azure VM (Linux Box) 

 

I m able to publish report to Power BI Service from LAN.

However, I m unable to add new data source on the gateway.

 

Are there any additional configurations that are necessary on PBI Gateway/ Azure?

 

Thanks,

Mannu

Status: Needs Info
See more ideas labeled with:
3 Comments (3 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎09-21-2017 01:47 AM

Hi @Anonymous,

 

1. Was this data gateway installed on the same machine as Imlapa database hosted? If not, please make sure the from the machine hosted data gateway can access remote Imlapa. 

2. From the screenshot, I find you use Anonymous authentication to access the Impala. Please double confirm if it really doesn't require any credential. 

3. Please update the data gateway to the latest version( https://go.microsoft.com/fwlink/?LinkID=820931 ). 

 

Best Regards,
Qiuyun Yu 

Vicky_Song
Impactful Individual
Impactful Individual
‎09-21-2017 01:47 AM
Status changed to: Needs Info
 
Anonymous
Not applicable
‎10-04-2017 09:23 PM

Thanks. I believe the firewall restriction was the culprit. The issue is now resolved.

Idea Statuses