Fix the Microsoft ACE OLEDB Provider Error in Power BI and Access
Question details
Connect Power BI to an Access database without an ACE OLEDB provider or version error.

- Product
- Microsoft Power BI Desktop and Microsoft Access
- Device & OS
- not provided
- Scenario
- Power BI needs to read an Access database that contains linked SQL Server tables.
- Observed behavior
- Power BI reports that the Microsoft.ACE.OLEDB.12.0 provider is not registered. Attempts to install Access Database Engine versions cause architecture or version conflicts, and a later connection attempt reports that a newer version of Access is required.
Check whether Power BI Desktop and Office are 32-bit or 64-bit, and note the installed Access Database Engine versions. Confirm that you can access the database file and have permission to change installed software.
Install an ACE provider compatible with Power BI and Office
Use this approach when the ACE provider is missing or its architecture conflicts with Power BI or installed Office components.
The ACE provider must match Power BI Desktop's bitness. Installed Office components can also restrict which database engine packages can be installed, so check both before making changes.
In Power BI Desktop, open Help > About and check whether the installation is 32-bit or 64-bit.
In an Office app, open File > Account > About and check the bitness. Then open Windows Settings > Apps > Installed apps and look for Microsoft Access Database Engine or Access Runtime entries.
If the installer reports a conflicting Office or database-engine component, review the named component in Installed apps. Uninstall or replace it only if needed and authorized; changing Office architecture may require reinstalling Office and other dependent components.
Download a supported Microsoft Access Database Engine or Microsoft 365 Access Runtime package from Microsoft, choosing the architecture that matches Power BI. Run the installer and follow any compatibility guidance it displays.
Restart Power BI Desktop, select Home > Get data > Access database, choose the database file, and try loading a table.

Investigate the newer Access version message
Use these checks if the provider is installed but Power BI still says the database requires a newer version of Access.
Work with Office documents in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface and compatibility with common Microsoft Office formats, making it easy to move everyday documents and spreadsheets. It does not install the ACE provider or fix the Power BI Access connection.

Frequently Asked Questions
Does the ACE provider need to match Office or Power BI?
The provider must match Power BI Desktop's bitness. Office bitness and installation technology can also affect which provider package will install, so check both Power BI's Help > About screen and Office's File > Account > About screen.
Why does Power BI say the ACE provider is not registered?
The provider may be missing, inaccessible to Power BI, or installed with a different architecture. Check installed Access Database Engine or Access Runtime entries in Windows Settings > Apps > Installed apps, then install a compatible Microsoft package.
What should I check if Power BI says the database needs a newer Access version?
Open the file in Access using File > Open and check for a format or version message. Also test its linked SQL Server tables and try connecting Power BI to a simple Access database to narrow down the cause.
Can WPS Office fix the Power BI ACE provider error?
No. The connection requires a compatible Microsoft ACE provider and a usable Access database. WPS Office can work with exported spreadsheet data, but it does not install the provider or repair the connection.




