Error OLE DB or ODBC

[jracer007]

Hello community, today I come to ask you why this error occuree when I am going to update a data source?

[Anonymous]

Hi all, 

I found this video that might be helpful. I could solve the issue thanks to it. You just need to check if the data type of the columns is correct (check this in Power BI Power Query) . They should also match the data type you have in your DataBase or data source. 

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

Hope this will help others!

[mehaboob557 · Accepted solution]

Hi @jracer007,

Go in edit queries. then clicl on source and update this in that [ReturnSingleDatabase=true, OldGuids=true, CommandTimeout=#duration(0, 1, 0, 0)])

may be some data will be not in a correct format. so this error may occur.

add with OldGuids=true in your source and your error will go.

Hope this may help you

regards,

Mehbub