Forum Discussion
Power query Refresh paused as file is open by another user on SharePoint Site
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.
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.