Azure Synapse Data Flow Linked Data Set table not populating

[j11codep]

I have a pipeline with a data flow that terminates in a sink that points to a linked data set (a sql server table). When I debug the pipeline, I can see that the sink data preview contains the rows I expected it to have. However, the actual sink table doesn't get populated by these rows. What am I missing? Thank you