cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Hive Hortonworks ODBC Connector refresh error on Power BI Service

Hey Everyone,

I am using Hortonworks ODBC Connector to fetch my data that resides in Cloudera Hive. The connection has been established succesfully and I am able to fetch and refresh data in Power BI Desktop. 

I am able to also able to publish the Power BI File to Power BI service. My On Premise Gateway has been set up and configured correctly. 

The Problem arise when I try to refresh my data in Power BI Service. The error states that the table cannot be found.


Something went wrong
There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"ODBC: ERROR [42S02] [Hortonworks][SQLEngine] (31740) Table or view not found: HIVE.rvm.agg_closing_stock"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Odbc"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"dsn=EDO_HIVE"}},{"code":"Microsoft.Data.Mashup.ValueError.OdbcErrors","detail":{"type":1,"value":"#table({\"SQLState\", \"NativeError\", \"Message\"}, {})"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: agg_closing_stock_2.
Cluster URI: WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net
Activity ID: 127fe6dc-db41-4657-bbaf-0d1d0b76545d
Request ID: 990ec939-0db4-6ef6-1bc3-bb54ea48cf8f
Time: 2020-10-07 09:05:55Z 

I have looked through the error number. But didn't find anything solid to help me resolve this issue.
Any help would be appreciated.

Thanks.

 


 @amitchandak 
@Greg_Deckler 
@parry2k 
@Cmcmahan 
@Icey 
@Eric_Zhang 

 

2 REPLIES 2
Highlighted
Super User II
Super User II

Are you sure the gateway is set up correctly? Same ODBC driver, access to Hive is validated and sufficient, and you can reach the table with your Hive query tool from the gateway?

 

Table or view not found: HIVE.rvm.agg_closing_stock

 

 

Highlighted
Community Support
Community Support

Hi @Apoorv_Lunawat 

Could you tell me what kind of connection mode you use?

Here is a simmliar blog like yours , and I hope it could help you solve your problem.

 

Please check did you make some change on the data source, just like change the file name, file postion and so on.

 

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors