Forum Discussion
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 rep...
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.