Forum Discussion
Power Query locking when someone opens a separate referenced Pivot table file
I created a power query to import .csv files from a few folders and reformat them / merge data from other files etc. I created a sepearate Pivot table excel file that about 10 managers use to see th...
Either set the file to not refresh on open, or move the CSV files to SharePoint libraries. Those do not cause a lock and multiple apps can read them at the same time. This is one of many reasons I store files in SharePoint vs local network or local PC drives. I never deal with file locks for data source files.
Thanks. I will give that a try. I am a bit new to Power Query. this is my first project using it as opposed to writing lengthy macros. would my master power query file go on sharepoint as well? or just the .csv files i am ingesting?