Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
When refreshing all tables from a MS Access database, PowerBi throws an error for one table: "Could not use 'db.accdb'; file already in use" and throws another error for the other tables: "Load was cancelled by an error in loading a previous table". It's not always the same table that receives the first error.
The file is not in use as I can manually refresh individual tables.
I think what happens is PowerBi opens a new connection for every table it tries to refresh even if it is from the same source/database and creates a lock file everytime. The lock file gets deleted after one table gets loaded and a new one is created for the next table, but at some point the lock file seems to not get deleted quick enough so when PowerBi tries to load another table (with a new connection), it sees the lock file still there and throws the errors.
Solution would be to wait for the lock file to get deleted before trying to load another table.
Extra Infos:
Windows 10 64bit
PowerBi 32bit
MS Access 32bit
db file:
.accdb
network location
17 tables
500-1000 rows per table
pbi file:
desktop
nework location
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.