This is really frustrating and to be honost this is not the first time it happens to me i have a very critical and important work that i need to finish and i can't understand why this issue is happening to me, it seems that the compatibility of the data types between excel and PBI is not coreectly done.
My issue is that i keep getting this message:
The input couldn't be recognized as a valid Excel document
Whenever i try to get the data from my excel datasheet with one column of type short date, i have tried deferent date formats and i'm still getting the same error message, i remember this was never an issue before and i could've use the same file as data source without a problem before this new year update.
Please let me know how i can solve this issue, as i'm running in very tight deadline and i have to finish a donor report.
PS: I looked at this issue and it doesn't solve anything : Click Here