Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
U156531
Post Patron
Post Patron

Access database locked when performing Refresh

I have an Access Database that is used as input along with other database. There are two queires in the PBI report that query the same Access database. When I try to use the Refresh button in the report I get the following error. "The database has been placed in a state by user 'Admin' on machine 'EXPC1' that prevents it from being opened or locked".  Under Setting- Options - I have 

U156531_0-1707845019066.png 

This doesn't resolve it.

 

I've turned of the Enable Load in the Queries panel for the two queries that access the same Acess Database and that resolves the issue but then I have remember to manually refresh the two queries. 

 

Is there something else I can try to resolve the error?

 

Thanks

 

1 REPLY 1
christinepayton
Super User
Super User

My guess is this is something on the Access side, not on the PBI Desktop side. Access is not really my thing, but I have had issues accessing SQL tables when they're locked by another user - Power BI tries to lock it while it's refreshing so that the data doesn't change while it's getting queried. Not sure if you're the owner of the database or not but I'd check on that end of it. 

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors