BI Service error: Microsoft ACE.OLEDB.12.0 not registered, mdb file from SharePoint

[Dellis81]

Hello - I have a datamodel pulling .mdb files from Sharepoint.   The refresh process works great at the desktop level.

Now, I am wanting to publish, and then setup auto refreshes within the Service.   Unfortunately, I am getting this error.

BI Service error while attempting refresh

Since this is at the "Service" level, this error message doesn't make sense.

Again - hoping to pull in both excel and mdb files from a Sharepoint location.

I have found same issue posted on the forum, with no known solution.  I am hoping there are new developments within hte past few years to help me get thru this.

thanks

[GilbertQ]

Hi there,

As per the error you need to install the ACE driver on the Gateway Server.

Make sure that you download and install the 64bit version.

[Dellis81]

Thank you for responding and help 🙂

And maybe your response indicates confusion on my end.   I was under the impression, if we connected to SharePoint or OneDrive, we could avoid the Gateway connection within the Service.   Our ultimate goal is auto refreshes.  
Thank you!

daryl