Skip to main content

Power BI

Needs Votes

Unable to refresh the Excel Workbook file (.xlsb files) from Power BI service.

Vote (5) Share
Prasoona Pokala's profile image

Prasoona Pokala on 20 Oct 2020 13:41:06

Hello Team,

We are trying to refresh the Excel file(.xlsb) in SharePoint from the Power BI service and getting the below Error.

'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'.

For getting refresh successful, We need to install the mentioned driver from the link. As the share point is the cloud source, we are unable to install the required driver.

So we need to convert the .Xlsb file in order to succeed the refresh.

It would be helpful if you implement the refresh of .xlsb files without converting it in the near future of the Power BI releases.