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:...
Hi,
I had the same issue and the way that I resolved it was change my file extension from xls to xlsx. The problem just ocurring when I try to refresh dataset on power services.
"Power BI supports importing or connecting to workbooks created in Excel 2007 and later. Workbooks must be saved as .xlsx or .xlsm file type and be under 1 GB. Some features described in this article are only available in later versions of Excel."
Hi Anonymous , what if I can't change the source's extension?