Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
hmpatel9
Frequent Visitor

Impala issue This data source cant be accessed by a data gateway :Server:Imapla;Database:Extension

Hello All I am fairly new to PowerBI ,we are trying to connect our onprem Impala CDH vai a gateway in the PowerBI service but we are always getting the message

 

This data source cant be accessed by a data gateway :Server:Imapla;Database:Extension 

 

We have used the IP address for the Connection in powerBI desktop and are creating the Source under our gateway with the

same IP address .

 

The gateway as such works for other datasources like SQL . Its just that with Impala it does not work.. please help as we are stuck 

 

 gateway.pngDesktop_IP.pngGateway_error.png

1 ACCEPTED SOLUTION

Thanks v-yuezhe-msft .. I was able to get the report working after I installed the Latest Gateway I did the following

 

In Power BI Desktop

Under Options and Settings >> Datasource Settings

I did Clear Permissions at lobal level and then republished the report

The Name in the Data source was kept as the IP

In server Name I put IP:21050

 

and it started working ..

 

Thanks v-yuezhe-msft ..  

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

@hmpatel9,

Do you use the latest version of Power BI gateway? When I try to add a impala data source within gateway, I have the following screenshot.
1.JPG

In your scenario, you would need to make sure that the connection string used in Power BI Desktop is same as that you used in gateway. In your Power BI Desktop, there is no port(21050) in the server name, thus, when you add data source within gateway, you should remove port from server name. In addition, ensure that you use same Authentication method for impala data source in Power BI Desktop and gateway.

Regards,
Lydia

Thanks v-yuezhe-msft .. I was able to get the report working after I installed the Latest Gateway I did the following

 

In Power BI Desktop

Under Options and Settings >> Datasource Settings

I did Clear Permissions at lobal level and then republished the report

The Name in the Data source was kept as the IP

In server Name I put IP:21050

 

and it started working ..

 

Thanks v-yuezhe-msft ..  

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors