Forum Discussion
neilingoe
Oct 09, 2019Copper Contributor
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. ...
SergeiBaklan
Oct 09, 2019Diamond Contributor
neilingoe
Oct 09, 2019Copper Contributor
I saw that suggestion on another thread: tried it, no change.
- SergeiBaklanOct 09, 2019Diamond Contributor
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?
- neilingoeOct 09, 2019Copper Contributor
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.
- SergeiBaklanOct 09, 2019Diamond Contributor
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.