Forum Discussion
Excel xlsb file type Refresh Fails
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 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.