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 credentials in PowerBI Online I get a message saying that that particular Temp File is being used.

 

BEFORE: 

 

 

AFTER:

 

 

PERSONAL GATEWAY

 

Does anyone has a clue?

 

 

General Comment

3 Replies

  • v-diye-msft's avatar
    v-diye-msft
    Community 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
        Community 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!