Forum Discussion

alexumagba's avatar
alexumagba
Frequent Visitor
3 years ago

Schedule refresh failed

I have this error Microsoft Access: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. The 64-bit version of the Access Database Engine OLEDB provider may be required to ...
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi alexumagba ,

 

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.

More details: Get data from Excel workbook files 

 

You can follow any of below :

1. Update your source file to .xlsx (Change the file suffix instead of simply renaming it).

2. Configure a gateway and install 64bit version of Microsoft.ACE.OLEDB.12.0 on gateway server, then create a data source for your source file (even it's on SharePoint) and use that to refresh your dataset.

 

Are your xlsx files saved in SharePoint? Please refer to this document and it may be helpful for you.

I found some similar posts for you, you can also refer to the solutions of the following posts.

Solved: MS Access dataset on Sharepoint - "Microsoft.ACE.O... - Microsoft Power BI Community

Solved: MS Access in Share Point issue - Microsoft Power BI Community

Solved: There was an error when processing the data in the... - Microsoft Power BI Community

 

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.