I have connected to a single table in excel and whenever I try to close and save the query editor, I get the above message. In reviewing the table in query editor I see the bottom row is all errors; however, when I try to delete the bottom row the entire table goes away and the same error message appears in the query editor.
Any suggestions on how to correct this would be appreciated.
In addition to Marcel's comment, have you tried removing errors as a step in your query editor flow? If that doesn't work, you can try filtering, and lastly add a new column that checks if the value is error return null otherwise return the original value. Then use that column (and remove/filter the blank row if needed).