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.