Forum Discussion

hmpatel9's avatar
hmpatel9
Frequent Visitor
8 years ago
Solved

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 b...
  • hmpatel9's avatar
    hmpatel9
    8 years ago

    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 ..  

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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.


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

hmpatel9's avatar
hmpatel9
Frequent Visitor
8 years ago

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 ..