Forum Discussion

HariBP's avatar
HariBP
New Member
4 years ago
Solved

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 erro...
Need Help
  • HariBP's avatar
    HariBP
    4 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.

 

 

  • HariBP's avatar
    HariBP
    New Member
    4 years ago

    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.