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
7 years ago

I apologize if this is repetitive (I am not a developer/programmer - a wannabe).  This question seems similar to mine, but my error was the result of creating a query with multiple excel files (FY11-FY19) in a folder.  Can you explain what the issue is and how I can fix it?

 

 

  • idkwhatimdoing's avatar
    idkwhatimdoing
    Icon for Advocate I rankAdvocate I
    2 years ago

    check that the tabs are consistent in their naming convention in each workbook AND that it's what it was named when you intially set it up. othewise, open your navigation steps and make corrections