Data Factory
PlannedReporting the column that causes a String or binary data would be truncated error
Pasquale Massimo Scorca on 10 Jul 2024 15:19:29
Hi,
recently working with a dataflow gen2 I've obtained a such error:
"Mashup Exception Data Source Error Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: DataSource.Error: Microsoft SQL: String or binary data would be truncated."
without any reported columns related to the arised error.
Detecting the right column that caused the error is a very long and tedious work, specially when the source columns are many!
I think that it is very important to know the wrong column in a such scenario or similar ones.
Thanks and bye
Administrator on 30 Sep 2024 21:34:07
We're planning to bring a validation experience to Dataflow so you can get notifications of possible failures based on how your Dataflow is configured