04-23-2017 06:47 PM
We also encountered this error, but had a different solutoin.
For us, the fix was to change our Regional Settings to "English (United States)", rather than English(Australian). (Do this from the main menu > Options and settings > Options > Regional Settings)
The reason we were getting so many date errors was because PowerBI was trying to convert the dates into the Australian format of DD/MM/YYYY, rather than the US format of MM/DD/YYYY.
Once we changed our Regional Setting, the errors disappeared and all dates were converted correctly to Date type.