Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
SonjaBriers1966
Frequent Visitor

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.

1 ACCEPTED 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.

View solution in original post

4 REPLIES 4
v-yingjl
Community Support
Community Support

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.

v-yingjl
Community Support
Community Support

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.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.