More Detailed Errors

[Aaron301]

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.

[jennratten]

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.

[foodd]

Thank you for starting a conversation in the Power Query Forum.   As this is related to MS Fabric and Gen2 Dataflows , would you please consider moving this post to the Developer Forum where they more closely follow these types of questions?

Developer - Microsoft Fabric Community

[Aaron301]

Dataflows is basicall PQ isn't it? And I went through the Help ribbon in it to get here but sure.

[foodd]

Sorry, that should be the Service forum.

Service

Power BI Premium, Dataflows, dashboards, reports, sharing, and everything else you do at app.powerbi.com.