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?
