Forum Discussion

Heavieth's avatar
Heavieth
New Member
3 years ago

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? 

1 Reply

  • Hi Heavieth 

     

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