Forum Discussion
Enterprise Gateway With MS Access
Can the Enterprise Gateway be connected to MS Access? I don't see Access listed here.
We've been able to connect to MS Access via the OPDG by using an OLEDB connection (i.e. Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\filepath\filename.accdb;). The problem is that the gateway maintains a lock on the accdb file, preventing it from being updated.
What'd be ideal is if microsoft would support refreshing from OneDrive or SharePoint Online which would eliminate the need for a gateway altogether. When we try this we get 'ACE OLEDB provider is not registered on the local machine' errors...keeping in mind this error is being thrown from the Power BI service, NOT from the client running Power BI desktop.