Forum Discussion
Power BI cannot refresh automatically
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
Hi
Unfortunately, the service cannot use Access or OLEDB connectors. Workarounds:-
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 !!
-
4 Replies
Hi
Unfortunately, the service cannot use Access or OLEDB connectors. Workarounds:-
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 !!
-
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
Hi felipevannier ,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you
Hi felipevannier ,
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
