cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
abhi1488
Regular Visitor

Unable to load Hive tables in PowerBI

 

Hi,

 

I am trying to connect Power BI with Hive table; for this I am using 64 bit MapR ODBC driver. I have created the DSN on my system and it test successfully. However when I try to connect hive; it connect successfully but once I select a table to load it throws folllowing error:

 

DataSource.Error: ODBC: ERROR [HY000] [MapR][Hardy] (35) Error from server: error code: '0' error message: 'MetaException(message:java.lang.NullPointerException)'.

Details:

    DataSourceKind=Odbc

    DataSourcePath=dsn=<DSN NAME>

    OdbcErrors=Table

 

With the same dsn, I am able to load the data in Tableau and Teradata Sql Assistant. Moreover, if I define my query (SELECT * FROM TABLE) in the advance option then I am able to load data from hive in Power BI.

 

Any idea what might be the reason behind such behaviour

 

Thanks in advance

1 ACCEPTED SOLUTION

Accepted Solutions
abhi1488
Regular Visitor

Re: Unable to load Hive tables in PowerBI

Thanks,

 

I downgraded my MapR Hive driver to 2.15 version and it worked successfully.

View solution in original post

3 REPLIES 3
abhi1488
Regular Visitor

Re: Unable to load Hive tables in PowerBI

Any help on this??

Moderator v-yuezhe-msft
Moderator

Re: Unable to load Hive tables in PowerBI

@abhi1488,

Do you use the 64-bit and latest version of Power BI Desktop(2.50.4859.502) to connect to the data source? Please follow the guide in this blog to connect to Hive data source by installing Microsoft Hive ODBC Driver and check if you get any errors.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
abhi1488
Regular Visitor

Re: Unable to load Hive tables in PowerBI

Thanks,

 

I downgraded my MapR Hive driver to 2.15 version and it worked successfully.

View solution in original post

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors