Forum Discussion
mike_honey
Memorable Member
Memorable MemberDataset Refresh error Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine
I built a report using PBI Desktop - the source is an Excel file on a public website (not OneDrive). When I publish it and then try to use the Power BI site to refresh the dataset, I get this error:...
My report was compiling XLS files from a sharepoint folder. Everything worked fine on PBI Desktop. When I published to Service, I received this same error when refreshing dataset. As suggested in other answers, I converted all the XLS to XLSX and the problem went away. (Note- I did not simply rename, I opened with Excel on the web and chose Convert when it asked me.)