Forum Discussion

thomaskelly's avatar
thomaskelly
Icon for Helper I rankHelper I
9 years ago
Solved

Unable to "Apply Query Changes".

Hello,   I merged two tables from a MySql connection in power query, however when i go to apply these changes the process times out and only reaches 6335 lines out of 800,000+ so a long way to go. ...
Need Help
  • thomaskelly's avatar
    thomaskelly
    9 years ago

    Hi Lydia

     

    I have rebuilt the data set from the ground up starting with all of the tables from one Sql server then making changes to these before introduction the tables from another sql server.

     

    This seems to have fixed the issue, and the report is refreshing in minutes when before just making one change in the query was taking hours to update.

     

    Thanks for you help and comments :-)

     

    Kind Regards

     

    Thomas

Anonymous's avatar
Anonymous
Not applicable
9 years ago

thomaskelly,

I would recommend you check that if you can increase query timeout or connection timeout value on MySQL server side.

Regards,
Lydia

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
9 years ago

are you loading more than one query at once?  

 

i know in the past when i have changed this setting it has helped  - untick the paralell loading