Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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).

Need Help

1 Reply

  • ibarrau's avatar
    ibarrau
    Super User
    3 years ago

    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,