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

[Anonymous]

Hi,

I recently changed a query in SQL that is linked to a graph in Power BI. The query works perfectly in SQL; however, when I try to refresh the dashboard it gives me the error OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E

If I refresh the table itself there is no issue, but the information from the query that was modified is not showing. Does anyone have any tips to fix this issue?

Thank you.

[amitchandak]

@Anonymous ,

Can open transform data/ edit query mode and check the error there. And try to fix any common problem

refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs

debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s

[Anonymous]

Hi @amitchandak thank you very much for the quick response.

It doesn't seem to be an issue when I go to the queries section.

[amitchandak]

@Anonymous , refer if these can help

https://www.youtube.com/watch?v=iVY1GkiYs-U

https://www.youtube.com/watch?v=bmKYOiJt4EM

https://community.powerbi.com/t5/Desktop/REFRESH-ERROR-OLE-DB-u-ODBC-Exception-from-HRESULT-0x80040E4E/td-p/913510