Forum Discussion

blm001's avatar
blm001
Advocate I
5 years ago

PB Service Query error : Microsoft.ACE.OLEDB.12.0

Hello, I have looked for hours for a solution, but no luck.  I have also read many posts on the site, but no fixed to the issue.   The issue: On the PBI Service (Desktop works perfectly), when it...
Need Help
v-yingjl's avatar
v-yingjl
Community Support
5 years ago

Hi blm001 ,

As far as I know, currently .xls file would use Access engine in Power BI.

Please try to download the corresponding bit version of Access Engine as the error message mentioned.

https://www.microsoft.com/en-us/download/details.aspx?id=13255

 

Here are the simliar articles that you can refer:

  1. Fix Power Bi error microsoft.ace.oledb.12.0 with these solutions 
  2. How to fix Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine 

 

In addition, if the error occurs when you attempt to open an .XLS file (an Excel 97-2003 workbook), you can avoid using the Access Database Engine by opening the .XLS file in Excel, and saving it as an XLSX file.

 

To convert multiple .xls files to .xlsx files, you can refer:

  1. How To Convert Multiple Xls Files To Xlsx Files In Excel? 
  2. batch-convert-xls-to-xlsx 

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

blm001's avatar
blm001
Advocate I
5 years ago

Thanks, but on my local machine it works fine.  The issue is on Microsofts' Power BI Service.

In other words the error is given on refreshing on the Service, not loclally on my machine. How can I download and install anything on Micorsofts Service?