DataSource.Error - The operation has timed out

Dear colleagues,

Hope you are all doing well. I just recently started experiencing this issue while trying to pull the data via Query directly in my excel Database.

After 5 minutes of waiting for the query to update, I receive this error.

Anyone has any idea on how to solve this?

Thank you!
Best,
Ismar

@ismarsalimovic, could you also share with the community the screenshot of the error that you see?

Dear Kal,

Here is the screenshot. Thank you for your quick response.

Best,
Ismar!

@ismarsalimovic, how good is your internet connection?

I tested via Speedtest.net, and it seems solid:

I also tried several more times, but keep getting the same error after 5 minutes of query processing…

@ismarsalimovic, what is the total submission of your project?

Around 26,000 submissions are currently in the tool.

@ismarsalimovic, would you mind sharing with me the following (through a private message) so that I could have a closer look at my end:

  • Username
  • Project name
  • Server
1 Like

@ismarsalimovic, did you try this API as discussed previously to load your data with Excel Power Query?