Forum Discussion
Solved
The input couldn't be recognized as a valid Excel document
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 g...
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 🙂
Hope it helps anyone!