Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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).
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,
Happy to help!
User | Count |
---|---|
45 | |
26 | |
21 | |
19 | |
18 |
User | Count |
---|---|
51 | |
45 | |
24 | |
24 | |
21 |