Error Code= 2147467259 MySql Timeout

[serrioal]

I have a number of queries that have been running completely fine for months and about a month or so ago, they simply stopped refreshing in PowerQuery inside Excel. I could see the tables and transform the data but could not load any records to a worksheet. Then I switched to PowerBi and that was working for awhile although a little painful having to continually export the data. As of last week PowerBi PowerQuery has now stopped working and I'm continually receving this error when trying to refresh my dataset. Again, I can see the tables and transform the data but cannot refresh. 

Any ideas?

[lbendlin]

Talk to your MySQL database people about index maintenance and ask them for the query plan for your queries.

[serrioal]

Just checked with him and the indexes are good. Any other suggestions?

[lbendlin]

what about the query plan?

[serrioal]

A-OK. Next step? Database adminstrator thinks there's something more fundamental happening. Thank you for the assistance and ideas.