PowerQuery Error: OLE DB or ODBC - Not sure what this means

[aishak12]

Hi All, 

Does anyone know what is the cause of this error:

Error Message:

Operation is not valid due to the current state of the object.

OLE DB or ODBC error: Operation is not valid due to the current state of the object..

[v-yangliu-msft]

Hi  @aishak12  ,

I'd like to suggest you check if the data source's status is ok. The error message usually means the file is corrupted. You may try to start from scratch after you have checked the data source. 

For related documents, you can check the following link:

https://community.powerbi.com/t5/Desktop/Operation-is-not-valid-due-to-the-current-state-of-the-obje...

https://community.powerbi.com/t5/Desktop/Cannot-import-a-folder-with-several-Excel-files-from-networ...
https://community.powerbi.com/t5/Power-Query/Function-crashes-Operation-is-not-valid-due-to-the-curr...

Best Regards,

Liu Yang

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

[lbendlin]

what type of data source are you connecting to? Did it ever work? when did it stop working?