Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi!!
I'm trying to connect a data source from sharepoint online, and even though I have installed the right version of Access Database Engine (it works with a local file), I kept getting this message.
How can I work it around?
{"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"Excel Workbook: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. The 64-bit version of the Access Database Engine 2010 Access Database Engine OLEDB provider may be required to read this type of file. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987."}}],"exceptionCulprit":1}}} Table: XXXXXX.
Hi @mcemim ,
As described in this official documentation, 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. So please make sure the related file extension is xlsx or xlsm first. Besides that, please check if proper Access Database Engine has installed in your machine. Please check if the solutions in the following links can help you.
Dataset Refresh error Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine
Can't import Excel (xls) into Power BI
You can submit a question about the issue to Power BI Support if the above solutions still can't resolve the problem.
Best Regards
Rena
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.