More Detailed Error Messages

[Aaron301]

Hello. While working with the dataflow gen2's in Fabric I keep getting errors like the following: "Value was either too large or too small for a Decimal." It seems a little silly that the column generating the error is not part of the error message and the value trying to be inserted isn't as well.

Am I missing something here? Is there a way to get more details? The table I am currenlty working on has over 600 columns and it has been taking time to track these down.

[GilbertQ]

Hi @Aaron301 

What about setting all of those columns to a larger data type?

[Aaron301]

No, I tracked down the error (which took a while) but I was hoping someone would know a better way to identify them in the future.