Enterprise Gateway With MS Access

We were able to refresh an MS Access datasource using the OPDG by leveraging an OLEDB connector. i.e. OLEDB connect string: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\fileshare_path\filename.accdb;.  However, we then found the gateway maintains a lock on the accdb file, preventing it from being updated.

What would be ideal is if Microsoft would support refreshing from an accdb file on OneDrive or Sharepoint Online.  This would eliminate the need for the gateway altogether.  When we try this we get ACE OLEDB bitness errors (and keep in mind these errors are coming from the browser using the Power BI service, not our client using PBI desktop).