Forum Discussion
Power Query - connection troubleshooting
I saw that suggestion on another thread: tried it, no change.
So, in destination file you have all rows but 98 from the source file and there is nothing that may cause error in row 98, correct?
Correct.
After the entry of one particular row, data subsequently added to the source file will not pull through, and the source file continues to work as normal.
I cannot see any error in that row or the source spreadsheet which may cause this issue.
Have tried rebuilding the destination file query from a new file, but I encounter the same error.
But you didn't add row 98, it somewhere in the middle. As I understood Power Query returns row 97 and all rows before that, as well as row 99 and all rows after it. Only this one is skipped.
Again, you are correct. There are two queries:
Sheet A Source --> Sheet A Destination - Data up to row 345 included. 346 onwards not pulled through.
Sheet B source --> Sheet B Destination - Data in Row 98 col M calculating correctly (formula in row 98 references row 346). Data is destination file sheet B shows results as though sheet A row 346 does not exist.
It's as though the ability to pull data from the file was lost after that row was added.