I was importing data from Excel to Power BI and I received this error:
DataFormat.Error: The input couldn't be recognized as a valid Excel document. Details: Binary
It was caused by the first row being set to freeze panes. After I open the spreadsheet and selected un-freeze panes, it imported successfully.