cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CBAnalytics
New Member

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

Hi all,

 

I am getting the following error. How can I fix this?

{"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"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 2010 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."}}],"exceptionCulprit":1}}} Table: Zootecnico AG Macho.

My data source is located in cloudfront (Amazon), my client updates the Excel files and I use it.
My Power BI is 64 bit and I don't know my client's Office version (I don't know if it matters).

I've already downloaded the Access Database Engine and set Data Source Credentials as Organizational and still doesn't work. 

5 REPLIES 5
rupesh22
New Member

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

Thank you, this helped solve my problem. 

yh_low72
Regular Visitor

Hi,

I'm getting the same error when PowerBi services reresh the dataset. and installed the 2 versions of Access Database Engine 32/64bit.


@yh_low72 wrote:

I'm getting the same error when PowerBi services reresh the dataset. and installed the 2 versions of Access Database Engine 32/64bit.


Have you tried re-starting the PBIRS service since doing the install?

d_gosbell
Super User II
Super User II


@CBAnalytics wrote:

I've already downloaded the Access Database Engine and set Data Source Credentials as Organizational and still doesn't work. 


Which version did you install? 32bit or 64bit? You can have both installed on your machine and you might need to restart Power BI after installing this. You need the 64bit version of this to read either Excel or Access files in Power BI (usually this is installed with Office, but if you have 32 bit Office you will need to install the 64bit provider in order to work with Power BI Desktop)

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.