Power BI Refresh failing with Microsoft.ACE.OLEDB.12.0

[BridgetTompkin]

I'm refreshing the data, but an getting this error:

Excel Workbook: 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=28598

I have downloaded AccessDatabaseEngine_X64.exe, but it has made no difference.

Please can anone help. I have seen other posts about this, but have had no success following them.

Thank you

[v-cgao-msft · Accepted solution]

Hi @BridgetTompkin ,

Are you using source file in '.xls' format. if yes change file '.xls' to '.xlsx' and again refresh Power bi.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data