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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount 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.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors