Forum Discussion
Refresh data - scheduled refresh - Data source error
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 [ ] ERROR: Error executing query. Total time 0.171 seconds.\n\nQUERY [PROJECTION] [ERROR] \nQUERY [VIRTUAL] [ERROR] \nQUERY [JDBC WRAPPER] [ERROR] \nQUERY [JDBC ROUTE] [ERROR] Received exception with message 'Invali\njava.sql.SQLException: Error executing query. Total time 0.171 seconds.\n\nQUERY [PROJECTION] [ERROR] \nQUERY [VIRTUAL] [ERROR] \nQUERY [JDBC WRAPPER] [ERROR] \nQUERY [JDBC ROUTE] [ERROR] Received exception with message 'Invali;\nError while executing the query"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"DenodoForPowerBI"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"{\"DSN\":\"DenodoACC\"}"}},{"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: ib_gipsi_sidonie_sales_orderbook.
We created a Microsoft Support Ticket. The Microsoft Support team adviced us to reschedule the refreshments before 7:00 AM because we had too many loads between 7:00 AM and 10:00 AM.
4 Replies
Hi SonjaBriers1966 ,
What is your data source? Have you checked your data source and gateway work fine?
Maybe query is timeout, you can refer this document about scheduled refresh: Scheduled refresh timeout
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi SonjaBriers1966 ,
If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly. Thanks!
Best Regards,
Yingjie LiWe created a Microsoft Support Ticket. The Microsoft Support team adviced us to reschedule the refreshments before 7:00 AM because we had too many loads between 7:00 AM and 10:00 AM.
