Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Error when updating Credentials - Sharepoint Folder - Personal Gateways

I have a sharepoint folder synced to my machine. On PowerBI Desktop I connected via Folder to this sharepoint folder. There is a temp file showing, so I filtered it out and when I try to update cre...
General Comment
v-diye-msft's avatar
v-diye-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous 

 

Sorry I couldn't recognize the error prompted which not in English.

It seems that when you set up Power Query to open up files in a folder if one of the files is using by another person, then Power Query won't refresh but give the following error message

"[DataSource.Error] The process cannot access the file '..\file' because it is being used by another process.

 

Do you mean it?

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi v-diye-msft 

     

    Thanks for your answer. You are right, it says file is being used. This is the thread I was able to find more information:

     

    https://answers.microsoft.com/en-us/windows/forum/all/one-drive-file-849c9593-d756-4e56-8d6e/98f470db-5142-43c4-a30b-4d76176d561d

     

    This was happening I believe because I had several onedrive sync in some machines but I could not find the source. The error stopped to appear once I created the data source directly from a folder in Sharepoint.

     

    But based on the thread nobody knows how to fix it.

     

    Thanks for trying though 🙂

    Barbara

    • v-diye-msft's avatar
      v-diye-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      hi Anonymous 

       

      Thanks for your updates! Happy to know you've fixed that, would you mind kindly mark your answer as a solution to finish this thread? thanks a lot!