Showing results for 
Search instead for 
Did you mean: 
New Member

Power Bi On Premise Data Gateway (Access Databases remaining locked for editing after refresh)

I have on On Premise data gateway functioning to where I have cloud Power Bi refresh automation set up. Everything works fine except the Access Databases on the server that I use as a front end for connections is remaining locked for editing after the refresh. These are very active databases and must be released. Any ideas on what could cause this and a possble work around? 

Super User
Super User

Hi @Heavieth 


As far as I am aware it should be able to read the Access file without locking it up

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Power BI Blog

Helpful resources

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.