Power query Refresh paused as file is open by another user on SharePoint Site

%3CLINGO-SUB%20id%3D%22lingo-sub-2837385%22%20slang%3D%22en-US%22%3EPower%20query%20Refresh%20paused%20as%20file%20is%20open%20by%20another%20user%20on%20SharePoint%20Site%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2837385%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20Power%20Query%20workbook%20which%20is%20shared%20and%20can%20be%20accessible%20by%20multiple%20people%20on%20a%20SharePoint%20site.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20someone%20makes%20an%20update%20and%20wants%20to%20refresh%20the%20Power%20Query%20workbook%20they%20get%20an%20error%20message%20to%20say%20another%20person%20has%20the%20workbook%20open%20and%20the%20query%20is%20paused.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEven%20going%20into%20the%20Data%20option%20and%20clicking%20refresh%20doesn't%20work..%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%20on%20a%20work%20around%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2837385%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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? 

0 Replies