When importing a sheet used in a named range, if the last row of the range is greater than the last row of the imported sheet, the named range resets to the last row of the imported sheet.
On the next import, if there are new rows, the range does not reset to all rows and queries setup with the named range do not evaluate all rows.
Terry can you please create a dummy/test connection and share that workflow with my email email@example.com? I need to be able to simulate the problem to submit this as a bug.
I am not sure what's different now but I went on and recreated the named range and this time it's working!