cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Enterprise Gateway With MS Access

Can the Enterprise Gateway be connected to MS Access? I don't see Access listed here.

4 REPLIES 4
Highlighted
Microsoft
Microsoft

@dmalsup,

Currently, enterprise gateway can't connect to MS Access, please use personal gateway instead to refresh the Access database.

Besides, there is an idea about adding Access as data source for enterprise gateway, you can vote it up.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted

Thanks for the information. I voted for this idea.

Highlighted
Frequent Visitor

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).

Highlighted
Frequent Visitor

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.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors