Forum Discussion
Helper IVError OLE DB or ODBC
Hello community, today I come to ask you why this error occuree when I am going to update a data source?
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
2 Replies
mehaboob557Resolver III
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
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!
