Schedule refresh failed

[alexumagba]

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 read this type of file. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987.

[v-tangjie-msft]

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. 

[alexumagba]

None of my data sources are xlsb. They are xlsx and access.

[lbendlin]

Access is the same as xlsb  (requires the driver to be installed on the gateway)

[alexumagba]

please how do I install the driver on the gateway

[v-tangjie-msft]

Hi @alexumagba ,

Has your problem been solved? If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out. Thanks in advance.

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. 

[lbendlin]

the same way you would install it on a regular PC.  To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987.

[lbendlin]

Don't use XLSB files as your data source.  Use XLSX or XLSM.