Solved: Query Timeout

Yunus_Miah · ‎10-23-2024

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.

zenisekd · ‎10-23-2024

Hi, you could check out this: https://stackoverflow.com/questions/51718344/how-to-set-a-max-run-time-timeout-for-power-query#:~:te...

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.

View solution in original post

zenisekd · ‎10-23-2024

Hi, you could check out this: https://stackoverflow.com/questions/51718344/how-to-set-a-max-run-time-timeout-for-power-query#:~:te...

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.