The input couldn't be recognized as a valid Excel document

[WesL]

Hello everyone.  Long time lurker, first time poster.  

I'm working with another department on getting some of their data into PowerBI from excel spreadsheets.  When I load the file to PowerBI I get a simple yet very frustrating error message of...

The input couldn't be recognized as a valid Excel document

Now this is a very complex spreadsheet with multiple tabs and lots of data.  Any commonly known issues that would prompt this error?

[mitsu · Accepted solution]

One of the reason could be that the data that you are importing to PBI is  not in excel table. Select the rows and columns from the sheet that you want to import >> Insert Table in excel and try importing it should be able to read the data then .

[mllopis · Accepted solution]

Please use the Issues Forum for reporting bugs or issues like this one. Link: http://aka.ms/issues.powerbi.com

This Community Forum is aimed at allowing users to interact/share solutions or questions for how to achieve something with Power BI, rather than reporting specific bugs (we have a whole separate forum for that :))

When reporting the issue, it would be good to clarify whether you're using PowerBI.com directly or are using Power BI Desktop to import your Excel Workbook. If you're using Power BI Desktop, any spreadsheet data is supported (does not need to be a table), so if you're running into this issue there, chances are that the Excel document has some invalid parts that make it unrecognizable.

Thanks,
M.