msouppaya
New member
- Joined
- Mar 24, 2021
- Messages
- 6
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 365 office
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. :yo:
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. :yo: