Hive Hortonworks ODBC Connector refresh error on Power BI Service

[Apoorv_Lunawat]

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 

[v-rzhou-msft]

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.

Enterprise Gateway with ODBC

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. 

[lbendlin]

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