Forum Discussion
cannot open or write to the file, it is already opened exclusively by another user or you need perm.
It is saying one of the files my access db is connected to cannot be opened or written to because it is already opened or need permission to view and write its data. The file in question is not opene...
Thanks for following up, the files are located on my local computer but they are saved on a shared drive (I confirmed no one else had the files opened).
I get the error when trying to update the data in power bi. I have the data linked to a Microsoft access db and am accessing it through that in BI.
Based on the error, it looks like a permissions issue, not a "file open" issue. So when you are running the update, is this being done using Power BI online via a gateway? Does this gateway have the correct file/folder permissions?