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

thomaskelly's avatar
thomaskelly
Icon for Helper I rankHelper I
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