Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.