Error Handling Functions Overview

Understand Error Handling Functions in Power Query M Language, vital for handling errors in your data manipulation tasks. This page provides a comprehensive list and descriptions of Error Handling Functions available in the M Language.

Error Handling Functions

FunctionDescriptionInputOutput
Diagnostics.ActivityIdReturns an opaque identifier for the currently-running evaluation.TextText
Diagnostics.TraceWrites a trace entry, if tracing is enabled, and returns the value.NumberAny
Error.RecordReturns an error record from the provided text values for reason, message and detail.TextRecord
BI Gorilla Blog

Last update: November 24, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/error-handling
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.