Query Timeout setting

Question

Hi Team,

I tried to make a query to a PostgreSQL (to put it into a data model) and my table has a timeout setting.

So everytime I query a large table, I will disconnect from the server because of the timeout limit setting, so it will cause this error:

So my question is, is there a way to make excel make some little batch queries (might be per time period) which will make some queries and at the end excel merge all of the table altogether?

and last but not least Thanks You for all of your help :)

Answer 1

Hi Laurent

If you use Power Query or the Get & Transform tools in Excel 2016 you can import the table in parts and append the parts

You'll have to break the large table into pieces yourself and append the pieces using the append query .

The question is if the server takes a long time to return the first row because of some heavy processing that needs to take place in the server or that the number of returned rows is so big.

If the cause is the first, breaking the table into manageable pieces will not help.

Dany Hoter (Excel team)

Answer 2

Hi Harsha,

Ohh ok, thanks you for the info and the link.

Regards,

Answer 3

Hi Laurent,

Welcome to Microsoft Community.

Since the issue involves SQL in excel Data Table your issue would be better addressed in the Excel IT Pro forums:

Click on the link below to post the query:

http://social.technet.microsoft.com/Forums/en/excel/threads

Thank you.