DataSource.Error - The operation has timed out

User Support Data Management
1

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

2

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

3

Dear Kal,

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

image
image1886×969 109 KB

Best,
Ismar!

4

@ismarsalimovic, how good is your internet connection?

5

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

image
image719×128 14.4 KB

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

6

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

7

Around 26,000 submissions are currently in the tool.

8

@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
10

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