Refresh Error - OLE DB ord ODBC

Thanks for the reply from Jai-Rathinavel, please allow me to provide another insight:

Hi, akosiRandy 

Regarding the issue you raised, my solution is as follows:

1.Firstly, have you changed the data format in the data source? (e.g., 2019/9/9 -> 2019-9-9). You can try creating a new date column instead of directly changing the data type.

Below are the screenshots of the relevant answers:

For more details, please refer to:

Solved: Getting the dreaded OLE DB or ODBC error: Exceptio... - Microsoft Fabric Community
 

2.Secondly, try to avoid using columns that contain special characters.

Below are the screenshots of the relevant answers:

For more details, please refer to:

Solved: 0x80040E4E Error - OLE DB or ODBC - Microsoft Fabric Community
 

3.Next, try deleting all steps in Power Query up to the Source step, then refresh to see if there are any errors. If no errors are displayed, paste the query steps back into the Advanced Editor.

Below are the screenshots of the relevant answers:

For more details, please refer to:

Solved: OLE DB or ODBC error: Exception from HRESULT: 0x80... - Microsoft Fabric Community

4.Finally, here is a related video that might be helpful to you:

OLE DB or ODBC error: Exception from HRESULT: 0x80040E1D | Power bi Refresh Error

Of course, if you have any new discoveries or questions, please feel free to get in touch with us.
 

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.