Refresh Timeout

[Anonymous]

Hi there, I have a report which shows a timeout error specifically on a single view across different reports. Any help in solving the issue would pretty much appreciated.

With regards,

[Icey]

Hi @Anonymous ,

Can you query the whole table in SSMS successfully?

Best Regards,

Icey

[Anonymous]

I was trying to refresh a specific view in the dataset which is giving me a timeout error across different reports. Any help regarding the issue would pretty much appreciated.

[ebeery]

Hi @Anonymous 

Click on the "gear" icon next to the Source step in your query.

Enter a number greater than 10 in the "Command timeout in minutes" parameter, under Advanced Options.

You may need to experiment with increasing the timeout until the problem is resolved.  By default timeout is set to 10 minutes, so if your query takes longer than that to respond it will fail.

[Anonymous]

HI @ebeery  I have tried that option by trial and error,i.e entering a series of values in the parameter, but still not solved.

[ebeery]

@Anonymous have you verified that the server/table/view that you're trying to access is actually responding properly in the source system?

[Anonymous]

@ebeery I can access it in the source system properly without any problem.

[AnthonyMathu]

Was this solved? I am having the same challenge with refreshing an API. i keep recieving the error "The refresh operation failed because it took too long to complete. Consider reducing the size of your dataset or breaking it up into smaller datasets."; I have followed the instructions to no avail