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.
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.
Solved! Go to Solution.
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.
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 Li
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.
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 Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
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.