Showing results for 
Search instead for 
Did you mean: 
kedarp Frequent Visitor
Frequent Visitor

Need help : Gateway configuration for ODBC to connect on premise hive

Hi all,
We are trying to configure "on premise data gateway(recommended)" to consume hive data through ODBC.


Referred below links of documentation


Having following queries:
- On premise data gateway (Personal) is not able to connect with hdfs, spark data sources.
Wondering if same is the case with on premise data gateway(recommended).
- on premise data gateway(recommended) supports ODBC data source through manual configuration but not live query.
Does this mean it will support connection to hive through ODBC as well?


Issues faced :
-Gateway installed and configured but giving eror as gateway not correctly configured in power Bi web service.


Little help and pointers over this would be really appreciated.


If anyone has already configured on premise data gateway for connecting to hive data through ODBC driver, step by step guidance/ example would be of great help.


Thanks and regards,


Helpful resources

Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 206 members 2,347 guests
Please welcome our newest community members: