Forum Discussion

Pratima's avatar
Pratima
Advocate II
9 years ago
Solved

How to Resolve this..... ?????

Hi All, How to Resolve this..... ?????   Details: "Microsoft Access: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. The 64-bit version of the Access Database Engin...
General Comment
Interesting Links
Show and Tell
Tips and Tricks
Tutorial Requests
  • Pratima's avatar
    Pratima
    9 years ago

    Resolved .......

     

     

    After  installing this AccessDatabaseEngine_X64 on my machine, error resolved

     

     

     

    Thanks,

    Pratima

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi Pratima,

 

First, please check the version of Office and Power BI desktop you have installed on your machine. As described in this document, this situation often occurs when the installed version of Microsoft Office is 32-bit, and the version of Power BI Desktop installed is 64-bit. The opposite can occur as well.

 

Then, from the error prompt, the ACE OLEDB provider is required to connect Access database so that it can fetch data from Access. So, please download Microsoft Access Database Engine 2010 Redistributable on your machine.

 

Best regards,
Yuliana Gu

Krishna09's avatar
Krishna09
Helper III
2 years ago

Hi v-yulgu-msft ,

How to connect power BI desktop with Access database Engine to import .xls file?