Error handling

 

The Power Query Formula Language is a powerful query language optimized for building queries that mashup data. It's a functional, case sensitive language similar to F#, which can be used with Power Query in Excel, Get & Transform in Excel 2016, and Power BI Desktop. To learn more, see the PowerQueryName reference.

FunctionDescription
Diagnostics.ActivityIdReturns an opaque identifier for the currently-running evaluation.
Diagnostics.TraceWrites a trace message, if tracing is enabled, and returns value.
Error.RecordReturns a record containing fields “Reason”, “Message”, and “Detail” set to the provided values. The record can be used to raise or throw an error.
TraceLevel.CriticalReturns 1, the value for Critical trace level.
TraceLevel.ErrorReturns 2, the value for Error trace level.
TraceLevel.InformationReturns 4, the value for Information trace level.
TraceLevel.VerboseReturns 5, the value for Verbose trace level.
TraceLevel.WarningReturns 3, the value for Warning trace level.
Show: