Forum Discussion
Excel xlsb file type Refresh Fails
I have a data source of an excle binary file type in onedrive. I have successfully create a report and published in Power BI service.
But if i try to refresh from Power BI service. It shows the error sign with errors:
"Processing errorExcel Workbook: 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."
Although i have installed everything it asked, it does not work.
I can do same thing for xlsx file type but cannot do for xlsb file type, why ?
In conclusion, Excel binary file type cannot be refresh from Power BI service. But I found the way out, we can refresh it using Gateway. Although Gateway is not necessary for Onedrive files, but for binary file type it is helpful.
5 Replies
Hi HariBP ,
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
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
In conclusion, Excel binary file type cannot be refresh from Power BI service. But I found the way out, we can refresh it using Gateway. Although Gateway is not necessary for Onedrive files, but for binary file type it is helpful.
Hi.
I know it's a little bit late, but I just solved this problem installing the Microsoft Access Database Engine on the Data Gateway server:
https://www.microsoft.com/en-us/download/details.aspx?id=54920
Hope this information helps someone.
Could you explain us how you did it? You need to install on which local? Do we need to set up a gateway first and then installing it in the same machine? Thanks
