Forum Discussion
MS Access in Share Point issue
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.
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.
Hi Anonymous
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:
1 Reply
Hi Anonymous
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: