0 Kudos

DataFormat.Error: The input couldn't be recognized as a valid Excel document. Details: Binary

Status: Needs Info
by lukpabi Occasional Visitor on ‎06-13-2017 11:59 AM

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.

Status: Needs Info
Comments
by v-haibl-msft Super Contributor
on ‎06-14-2017 10:35 PM

@lukpabi

 

I try to set the first row to be freeze panes, but still can import the excel 2016 file successfully with June 2017 version of Power BI Desktop.

Could you please share a sample excel which can be used to repro through online file service like OneDrive?

 

Best Regards,
Herbert

by Vicky_Song Established Member
on ‎06-14-2017 10:36 PM
Status changed to: Needs Info
 
by lukpabi Occasional Visitor
on ‎06-15-2017 05:46 AM

@v-haibl-msft

 

You set the first row to freeze panes?  The freeze pane setting needs to be removed for the file to be uploaded.

Idea Statuses