Power query rebuilds at every step during creation RRS feed

  • Question

  • I am creating a new power query that pulls in the contents of all xls files in a folder that match a certain criteria

    I also need to pull in additional information from an SQL server

    I am using the power Query add-in Version: 2.39.4526.123 32-bit on Excel 2010My issue is that on every step from the source step onwards the query engine runs through the entire folder to get information from 20 files, which takes 30 mins each time.

    xls files are much larger than the xlsx files and the power queries over the xlsx files do not appear to be having the same issue.

    Any ideas what I can do to stop this repeating the refresh at every step.

    sometimes I just want to remove a few columns!! nothing major


    Thursday, January 5, 2017 12:02 PM