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