MS Access in Share Point issue

[EvgenyZhutov]

Hello.

I have MS Access DB located in SharePoint.

I tried to connection from Power BI desktop and this connection availiable and working.

After that i publish this report, build correct credentials and try to update data.

And i give this error...

Something went wrong

There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.

MessageMicrosoft Access: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. The 64-bit version of the Access Database Engine 2010 Access Database Engine OLEDB provider may be required to read this type of file. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987. Table: TEST.

Cluster URIWABI-NORTH-EUROPE-redirect.analysis.windows.net

Activity IDb82fb023-ce50-48e4-b4cc-17486eeb0a88

Request IDac8eca6b-777f-7d4c-5148-1279f2acc885

Time2019-09-04 08:15:05Z

Power BI Pro and Power BI Premium versions.

[v-diye-msft · Accepted solution]

Hi @EvgenyZhutov 

It seems the provider hasn't been registered on the machine on which the application is running. The ACE provider is not installed on Windows operating systems by default. You have to install it.

Below blog could be your reference:

https://www.mikesdotnetting.com/article/280/solved-the-microsoft-ace-oledb-12-0-provider-is-not-regi...

https://www.connectionstrings.com/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-loc...