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

[Anonymous]

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

[ibarrau]

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,