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.
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.
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.
None of my data sources are xlsb. They are xlsx and access.
Access is the same as xlsb (requires the driver to be installed on the gateway)
please how do I install the driver on the gateway
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.
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.
Don't use XLSB files as your data source. Use XLSX or XLSM.
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.