Refresh Error - OLE DB ord ODBC

[akosiRandy]

Hi one of my powerbi report is failing on refresh, but other power bi report refresh with no issue. Anyone familiar with the error below and if there's a fix?

 

[Anonymous]

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.

[Jai-Rathinavel]

@akosiRandy Can you reconfigure or re-auntheticate the data source credentials and then check ?

Thanks,

Jai