You would need to post all your code but this is not completely unexpected and is due to streaming semantics which you can read more about here: https://bengribaudo.com/blog/2018/02/28/4391/power-query-m-primer-part5-paradigm