Forum Discussion
Power query Refresh paused as file is open by another user on SharePoint Site
Hi all,
I have a Power Query workbook which is shared and can be accessible by multiple people on a SharePoint site.
When someone makes an update and wants to refresh the Power Query workbook they get an error message to say another person has the workbook open and the query is paused.
Even going into the Data option and clicking refresh doesn't work..
Any ideas on a work around?
So the shared file's source file has sensitive key HR information, but is only a subset of the HR master file.
a work around can probably be tried.
1. The updates must be saved as a csv file into a specific folder
2. The shared power queried file must use query by folder so if someone tries to change the power query all they see is just the same subset information that was saved as a csv file in the specific folder
3 I haven't tried this but give it a try save the shared power queried file as a template so when someone opens it for whatever reason it does not really open the original template file but a copy of it so any number of users can open (a copy of the shared file and still update the query...this is an assumption because like I said I haven't tried it but in theory its worth a try)
I don't have share point so I can't test my theory.
This method should be Sarbanes Oxley compliant.
