Forum Discussion
DataFormat.Error: The input couldn't be recognized as a valid Excel document. Details: [Binary]
Hi, I had a report that was working daily (>365 days) until today. Today it no longer runs and has the error below. Nothing has changed in the source or the PBI Report. Could somebody ple...
Hi All,
I have struggled with the same issue. But didn't want to give up and finnaly resolved it!
My situation: I was getting xlsx file (with no table, just 1 sheet in it) inot my outlook every day.
This was essential file for my Power BI, to be updated every day.
After moving file to OneDrive or to Sharepoint, I was getting an error msg : Details: "The input couldn't be recognized as a valid Excel document." .
Solution: After speaking to a sender of this xlsx file , checking few things (like opening the file via notepad++) showed us that coding of that xlsx was incorrect.
The file was changed from xlsx to csv with UTH-8 encoding.
And everything is working just fine now.