Forum Discussion

rekgoor's avatar
rekgoor
Frequent Visitor
2 years ago

Authenticating the ODBC Hive source for scheduled refresh

Hello @, I've successfully created an ODBC connection for Hive data and was able to load the table without any issues. However, upon uploading it to the report server and attempting to authenticate ...
"scheduled refresh"
hive
ODBC
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Use basic auth, and make sure you test it in the ODBC64 system dsn control panel on each of the gateway cluster members.

rekgoor's avatar
rekgoor
Frequent Visitor
2 years ago

Basic authentication did not work. Although we have ODBC drivers for Hortonworks for Apache Hive created on the SQL instance, I'm using Cloudera for Hive, and I'm able to load sources into Power BI Desktop. However, I am unable to pass the test on data sources on Power BI Report Server web.Here, the Windows login and the Hive domain are definitely different.