Power BI cannot refresh automatically

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