Forum Discussion
More Detailed Errors
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 ...
Hello - yes, sometimes the error messages returned are not very helpful. One way that helps me is to press control + A to select all columns in the table, then select Keep Rows > Keep Errors. This will limit the rows to only those with errors. If you don't get any rows returned by this, try reversing the table (Table.Reverse) and trying again. You can also use Table.Schema to get your table's schema, which you can use to reference the different types for the columns and use Table.ColumnsOfType to select columns with specific data types.