That would demonstrate the problem you have. Question is how the CSV does look like after it left KNIME and what your BI does with it. My question would be if your BI tool could handle formats that would preserve the column type like parquet That could make the data transfer much easier. If you tell us which BI tool you use it could be possible to check if this is possible.