Showing results for 
Search instead for 
Did you mean: 
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

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Kudoed Authors