Forum Discussion
Power Query - connection troubleshooting
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.
neilingoe , not sure what it could be. Perhaps you may provide copy of your file removing all sensitive and extra information?
neilingoe , that's okay, thank you for sharing your finding
SergeiBaklan it appears the answer is "a pending Windows update".
It's working again now.
Sorry I wasted your time.
Unfortunately nothing concrete. Try to localise the issue - delete all other queries but one in question, don't load into data model if you do, remove top and bottom rows around one in question and like.
Unfortunately the whole file is sensitive data!
Are there any other diagnostics I could run to get to a possible cause?
- The source file data is still within the same table.
- I have tried removing and re-entering the data manually.
- I don't want to recreate the source data table as it's being fed by a lot of automations and I would have to redo those.
What would cause a query to break but not give an error message?