Forum Discussion
Error OLE DB o ODBC: [DataSource.Error] ODBC: SUCCESS_WITH_INFO [22008]
Hi dgianni,
The error likely means that the ODBC driver found at least one value in your data that is not a valid date or time. This can happen even if the data has not changed. Please follow below steps:
Go to Power Query Editor in power bi, find the date/time columns, open the Advanced Editor and add this below step:
let
Source = ...,
Cleaned = Table.TransformColumns(
Source,
{
{"order_date", each try Date.From(_) otherwise null},
{"ship_time", each try Time.From(_) otherwise null},
{"timestamp_column", each try DateTime.From(_) otherwise null}
})
in
Cleaned
This tells the power bi to ignore any invalid bad date/time values and replace them with nulls, so the refresh completes successfully.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thanks and regards,
Anjan Kumar Chippa
I do not see any errors in my DB... All the same as many years from now.
Do you know how can i update ODBC driver version?
Hi dgianni,
The error likely means that the ODBC driver found at least one value in your data that is not a valid date or time. This can happen even if the data has not changed. Please follow below steps:
Go to Power Query Editor in power bi, find the date/time columns, open the Advanced Editor and add this below step:
let
Source = ...,
Cleaned = Table.TransformColumns(
Source,
{
{"order_date", each try Date.From(_) otherwise null},
{"ship_time", each try Time.From(_) otherwise null},
{"timestamp_column", each try DateTime.From(_) otherwise null}
})
in
Cleaned
This tells the power bi to ignore any invalid bad date/time values and replace them with nulls, so the refresh completes successfully.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thanks and regards,
Anjan Kumar Chippa
Hi dgianni,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked.
If my response addressed, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Thanks and regards,
Anjan Kumar Chippa