Forum Discussion
Query Timeout
While attempting to pull data from a MySQL server via an ODBC driver into Power BI, I encountered a Query Timeout error. Each month contains approximately 1 million rows, and I'm trying to retrieve data spanning over 2 years. I've searched online for solutions, but the suggestions provided haven't resolved the issue.
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.
1 Reply
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.