Forum Discussion
Power Query - connection troubleshooting
Can anyone help me troubleshoot an issue with Power Query. Everything was working fine and then, after a certain time, I could no longer pull through new or updated data from the source file. ...
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.