Forum Discussion

whocares61's avatar
whocares61
Regular Visitor
2 years ago

The process cannot access the file because it is being used

So you are telling me that it's not possible to REFRESH the data in PowerBI Desktop when it's open in Excel? So I have to close the excel file every time I make a change, refresh, then open it again...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi whocares61 ,

 

Here I have a test on myside, I tried excel file in local and excel file online in sharepoint. Both of them work, I can refresh data in Power BI Desktop without closing the file.

Did this issue only appear on one file or all excel file would return this error? Did you use local file or online file?

You can update your credential or remove the table and get data again to have try.

And please download the latest version Power BI Desktop and try again.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

whocares61's avatar
whocares61
Regular Visitor
2 years ago

I just tried this one file and got discouraged to use the app. This kind of restriction seems 90s to me. You can see that Kedar_Pande telling you about the same issue.

 

File is stored in my OneDrive and I access it locally on my PC both the excel file and the PowerBI Desktop.

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    1 year ago

    Were you able to solve it? Previously I was allowed to update with Excel open, now for about +1 year here I have to close and it is annoying when a heavy Excel is occupied.