It's the dataset data ingestion issue,Lookups don't return data if there are duplicate records with same id, we need to update the existing record in the dataset, instead of creating a new row in the table the resulting in empty response due to multiple rows returned with same id.