Forum Discussion
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....
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,