Query Timeout

[Yunus_Miah]

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 · Accepted solution]

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.