Excel Power Queries break when updating source files

Alex 1 Reputation point
2022-06-29T22:54:09.053+00:00

I do a lot of work using power query in excel. I extract data from hundreds of files inside source folders on a shared server. The program keeps breaking (and is not recoverable saying the query lost connection) on me when I update the files inside a source folder (delete the old and paste in current). Is there a way to prevent this from happening?

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,798 questions
{count} votes