Power BI cannot refresh automatically

[felipevannier]

I'm trying to update my report which is connected with a microsoft access table in the company one drive server. 

Im facing this issue... can you help me?

I have installed Microsoft.ACE.OLEDB.12.0 in my own laptop as you can see below:

Data source error: DataSource.NotFound: Microsoft Access: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. The 64-bit version of the 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.. Microsoft.Data.Mashup.ErrorCode = 10478. . The exception was raised by the IDbCommand interface. Table: POR Compressed.
Cluster URI: WABI-US-NORTH-CENTRAL-G-PRIMARY-redirect.analysis.windows.net
Activity ID: f684d807-a370-4b4f-a02b-933e580b093a
Request ID: 6c3e0901-2f87-49a2-2e41-3d97cf07a406
Time: 2025-08-22 17:20:06Z

[v-sshirivolu]

Hi @felipevannier ,

I would also take a moment to thank @johnbasha33  , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions

[johnbasha33]

Hi  

Unfortunately, the service cannot use Access or OLEDB connectors. Workarounds:

1. Migrate your Access tables to a supported storage:

   • Save/export the Access tables to Excel and store on OneDrive/SharePoint.

   • Or move the data into SQL Server, Azure SQL Database, or another supported source.

   • Then repoint your report to the new source.

   • Use an On-premises Data Gateway:

     • Install and configure a Gateway on a server or your machine.

     • Add the Access file as a data source in the Gateway, using the ACE driver installed there.

     • Power BI Service will then call through the Gateway for refresh.

     • This is the official workaround if you must keep Access as the backend.

       🔹 If the error occurs only in Power BI Desktop:

       • Confirm whether you’re running 32-bit or 64-bit Desktop (Help → About → Version).

       • Uninstall the wrong version of Access Database Engine and install the matching bitness:

Download: Microsoft Access Database Engine 2016 Redistributable.

Choose AccessDatabaseEngine_X64.exe if using 64-bit Power BI Desktop.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

@felipevannier