Resolve unexpected data loss by checking "Include nulls" in Power Query text filters to retain missing values.