Forum Discussion

serrioal's avatar
serrioal
Regular Visitor
6 years ago

Error Code= 2147467259 MySql Timeout

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?

 

 

Need Help

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    6 years ago

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

    • serrioal's avatar
      serrioal
      Regular Visitor
      6 years ago

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