Thanks Ryan I did the same thing and it is now working. Let me explain. While loading data via the pipeline, in addition to putting data as a comma delimited value against the description as VectorValues nvarchar(max). I also added them as float in another table, against the Description Id (PK). I then created a view on top to combine these two tables on PK = FK and while picking up, I converted those child records (vector values) into json array.

This seem to have resolved the issue. and data is loading in the index.

SELECT 
     r.GIID
    ,r.ReportName
    ,r.[Description]
    ,JSON_QUERY('[' + STUFF((
                SELECT CONCAT(',', v.VectorValue,'')
                FROM dbo.ReportVectorData as v
                WHERE v.ReportGIID = r.GIID
                FOR XML PATH('')),1,1,'') + ']') AS VectorValue
FROM dbo.vwSearchReportsWithSecurity as r