Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Trouble refreshing data

Submitted by Anonymous on ‎10-20-2022 02:03 PM

Hi!

I have a problem while refreshing my data on power bi service, this is the 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=285987.

 

I already installed the Access Database Engine and still not working, any ideas?

Status: Investigating

Hi @Anonymous ,

 

Double check that you have properly installed the corresponding ODBC drivers:

If everything is set up correctly, check your Microsoft Office architecture (64 or 32 bit).

In case you are attempting to use ODBC on a 64-bit machine whilst your Microsoft Office version is 32-bit:

  • Download this installer here.

  • Do export the contents of the zip file to your desktop.

  • Exit WinAutomation from the system tray by right clicking on the WinAutomation action and selecting "Exit".

  • Right click on the executable file called "ForceDotnet32bitOnExeFiles.exe" and select "Run as Administrator"

This will handle all the configuration changes needed to be done so that you can combine a mix of 32- and 64-bit Office and Windows.

 

Best regards,

Community Support Team _Yadong Fang

See more ideas labeled with:
1 Comment (1 New)
Comments
v-yadongf-msft
Community Support
Community Support
‎10-21-2022 01:55 AM
Status changed to: Investigating

Hi @Anonymous ,

 

Double check that you have properly installed the corresponding ODBC drivers:

If everything is set up correctly, check your Microsoft Office architecture (64 or 32 bit).

In case you are attempting to use ODBC on a 64-bit machine whilst your Microsoft Office version is 32-bit:

  • Download this installer here.

  • Do export the contents of the zip file to your desktop.

  • Exit WinAutomation from the system tray by right clicking on the WinAutomation action and selecting "Exit".

  • Right click on the executable file called "ForceDotnet32bitOnExeFiles.exe" and select "Run as Administrator"

This will handle all the configuration changes needed to be done so that you can combine a mix of 32- and 64-bit Office and Windows.

 

Best regards,

Community Support Team _Yadong Fang

Idea Statuses