Hello everyone,

I made a query in Power Query (PQ) it runs (on SQL Server) in 2 minutes but when I try to refresh the query and load the data in Excel it takes 15 minutes to run to finally fall in error (execution time expired).

Suddenly I wonder if there is not a parameter in Excel to enable / disable to recover my data in Excel.

I tried to run it in VBA or manually it did not change the problem.

Under PQ the query is executed correctly.

I searched the internet without success.

On another forum I was told that PQ only retrieves the first 999 lines where my result returns more than 30,000 lines, which is why Excel would have a hard time.

An idea ? Thank you.