Forum Discussion

mike_honey's avatar
mike_honey
Icon for Memorable Member rankMemorable Member
10 years ago

Dataset 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:...
Vicky_Song's avatar
Vicky_Song
Icon for Impactful Individual rankImpactful Individual
10 years ago

mike_honey, as this article described: "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 250 MB". Currently, you need to change files from type .xls to .xlsx in order to fix this issue.

 

I understand the issue you're facing and will report back to PG team about your concerns. 

dcresp's avatar
dcresp
Icon for Advocate IV rankAdvocate IV
9 years ago

Vicky_Song is there any update on this one. As mike_honey says it seems a liitle rediculus that you can not refresh xls files and should not be that hard to fix.

Related content