Failure when updating data from sharepoint

[mcemim]

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.

[v-yiruan-msft]

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