Dobule OLE DB and ODBC error

[Anonymous]

Hi guys, 

this is becoming really frustrating and it was working few hours ago:

i have in 3 queries:

- OLE DB or ODBC error: Exception from HRESULT:0x80040E4E

and in another one

- OLE DB or ODBC error: Exception from HRESULT:0x80040E1D

do you know these errors what they relate to?

[v-juanli-msft]

Hi @Anonymous

Here are some similar threads in which some workarounds are mentioned. Could you go to check if it helps in your scenario?

https://community.powerbi.com/t5/Desktop/Getting-the-dreaded-OLE-DB-or-ODBC-error-Exception-from-HRESULT/td-p/147194

https://community.powerbi.com/t5/Desktop/0x80040E4E-Error-OLE-DB-or-ODBC/td-p/116683

Best Regards

Maggie

[Anonymous]

Not really sorry. 

And i can't reinstate query every time i have to update this. 

You have to come up with some solution that  tell the user where the problem is because for example this report works with the same type of data every time and it is hardly possible that  data can be corrupted. 

Power bi goes crazy everytime tho