List.ParallelInvoke

List.ParallelInvoke is a Power Query M function that evaluates a list of functions in parallel, optionally limiting the maximum concurrency.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

List.ParallelInvoke(
   list as list,
   optional concurrency as nullable number,
) as list

Description

Evaluates the provided list of functions with up to concurrency functions evaluated concurrently. The degree to which functions can be evaluated concurrently depends on the operations that they perform.

Examples

Construct the list {1, 2, 3} using 2 concurrent evaluations.

// Output: {1, 2, 3}
List.ParallelInvoke( {() => 1, () => 2, () => 3}, 2 )