Forum Discussion
Anonymous
3 years agoNot applicable
OLE DB or ODBC Invalid date, time or timestamp value
Hello, could you please share some ideas why Power BI refresh does not work? I see a lot of similar cases online and it seems that reasons and solutions for these can be different. I have particula...
- 3 years ago
Not sure, but try and see.
Can you screenshot D_SOPIMUS in Power query for me please.
aj1973
Community Champion
3 years agoNot sure, but try and see.
Can you screenshot D_SOPIMUS in Power query for me please.
Anonymous
3 years agoNot applicable
Thank you Amine!
It was actually invalid datetime value in specific column in dataset that was coming from Snowflake source table. I needed to correct that and after that refresh worked.
I would have been much better to have more descriptive error warnings. Even though there are three date columns in the dataset the error description did not point out to the column causing the problem.