Skip to main content

Data Factory

Planned

Reporting the column that causes a String or binary data would be truncated error

Vote (5) Share
Pasquale Massimo Scorca's profile image

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