Skip to main content
cancel
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.

Reply
LesnyLud
Regular Visitor

Auto SharePoint.contens data refresh failed Microsoft.ACE.OLEDB.12.0

Hello,

I've build a report which as asource use SharePointContent, the folder contains XLS (not XLSX files). It works correctly on desktop version but when I've planned autmatic data refresh in app.powerbi.com I get the error:

"<ccon>DataSource.NotFound: <ccon>Excel Workbook</ccon>: <ccon>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."

 

I've seen a solution to change xls to xlsx but it is not possible for me (the source file in the folder is created everyday by external server and iti is build in xls. Manual reworking every day is not an option).

1 REPLY 1
ibarrau
Super User
Super User

Hi. The thing is xls needs a driver in order to understand it. That means if you want to read xls you need a gateway, even if the file is hosted at sharepoint. That's why changing to xlsx is usually the alternative to keep it as cloud source. If you want to keep xls and install a gateway on a VM or server, then download de driver https://www.microsoft.com/en-au/download/details.aspx?id=13255

Then make sure to configure the Service to use it.

I hope that helps,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.