Forum Discussion

alderete-tomas's avatar
alderete-tomas
Frequent Visitor
3 years ago

OLE DB or ODBC error

I'm having the following error for the last three close n apply I've made in Power BI queries:

Asistencia
OLE DB or ODBC error: Excepción de HRESULT: 0x80040E4E. An unexpected exception occurred.
Empleados
La carga se canceló debido a un error al cargar una tabla anterior.
Ingresos
La carga se canceló debido a un error al cargar una tabla anterior.
Salidas
OLE DB or ODBC error: Excepción de HRESULT: 0x80040E4E. An unexpected exception occurred.
Atributos
La carga se canceló debido a un error al cargar una tabla anterior.
Antigüedad
OLE DB or ODBC error: Excepción de HRESULT: 0x80040E4E. An unexpected exception occurred.
Detalle de Ventas
OLE DB or ODBC error: Se ha terminado la conexión: Una conexión que se esperaba que se mantuviera activa fue cerrada por el servidor..
DIM_Nacionalidad
La carga se canceló debido a un error al cargar una tabla anterior.


The one that annoys me is that a conecction was closed by the server. What does it mean? How can it be fixed? or is the other error  HRESULT: 0x80040E4E causin to shut another query connection?

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi alderete-tomas ,

     

    Please try going to Power Query (Transform Data), and try refreshing every table to see from where the error is coming and it will show you from which step is getting the error and what it is.Then delete the loaded view/table  and re-imported the view/table in power query.

     

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.