Forum Discussion
Query Timeout
Hi, you could check out this: https://stackoverflow.com/questions/51718344/how-to-set-a-max-run-time-timeout-for-power-query#:~:text=Choose%20File%20%3E%20Options%20and%20settings,enter%20a%20Command%20timeout%20value
but my money would be on you using a poorly designed query.
If I were you, I would first check, if you are not pulling in unnecessary columns and if the query is designed so it was folding for as many steps as possible. Or perhaps write the query yourself in SQL and use native query.
Hi, you could check out this: https://stackoverflow.com/questions/51718344/how-to-set-a-max-run-time-timeout-for-power-query#:~:text=Choose%20File%20%3E%20Options%20and%20settings,enter%20a%20Command%20timeout%20value
but my money would be on you using a poorly designed query.
If I were you, I would first check, if you are not pulling in unnecessary columns and if the query is designed so it was folding for as many steps as possible. Or perhaps write the query yourself in SQL and use native query.