locked
Import errors using powerquery in Excel RRS feed

  • Question

  • I am using power query to upload data from other spreadsheet sources in excel using powerquery. When running the update I get a message that there are some errors

    Where can I see where the errors are?

    • Moved by George Hua Thursday, September 25, 2014 6:23 AM Moved from General Office Development forum
    Wednesday, September 24, 2014 1:46 PM

Answers

  • You should be able to edit the query and then pick "Keep Errors" from the ribbon in order to see just the errors in the result. (It's a little hard to find this option; you get to it by clicking the dropdown icon next to "Remove Errors".)
    Friday, September 26, 2014 1:32 PM

All replies