What causes Fabric Pipeline Error 2111?

A pipeline parameter or expression returns a value of the wrong type and is passed directly into an activity property. A hardcoded value in the activity JSON definition is the wrong type (e.g., a string where an integer is expected). Dynamic content expressions do not cast or convert output values before assigning them to typed properties. Copy-paste from another pipeline activity introduced a mismatched value type for a property

How do I fix Fabric Pipeline Error 2111?

Step 1: Identify the property named in the error message (the '%propertyName;' placeholder will contain the actual name) and the expected type ('%expectedType;').. Step 2: Open the pipeline activity in Fabric Data Factory and locate the offending property in the activity settings or JSON view.. Step 3: Check whether the value is hardcoded or sourced from a parameter or expression. If hardcoded, correct the value to match the expected type.. Step 4: If the value comes from an expression or parameter, add an explicit type conversion function (e.g., int(), string(), bool()) in the dynamic content expression to ensure the correct type is passed.. Step 5: Validate with a debug run and confirm the activity executes without the type error.

Medium severitydata formatMicrosoft Fabric →

Power BI Refresh Error:
Fabric Pipeline Error 2111

What does this error mean?

A property in the pipeline activity has been assigned a value of the wrong data type. The pipeline expects a specific type such as string, integer, or boolean, but received something different.

Common causes

1A pipeline parameter or expression returns a value of the wrong type and is passed directly into an activity property
2A hardcoded value in the activity JSON definition is the wrong type (e.g., a string where an integer is expected)
3Dynamic content expressions do not cast or convert output values before assigning them to typed properties
4Copy-paste from another pipeline activity introduced a mismatched value type for a property

How to fix it

1Step 1: Identify the property named in the error message (the '%propertyName;' placeholder will contain the actual name) and the expected type ('%expectedType;').
2Step 2: Open the pipeline activity in Fabric Data Factory and locate the offending property in the activity settings or JSON view.
3Step 3: Check whether the value is hardcoded or sourced from a parameter or expression. If hardcoded, correct the value to match the expected type.
4Step 4: If the value comes from an expression or parameter, add an explicit type conversion function (e.g., int(), string(), bool()) in the dynamic content expression to ensure the correct type is passed.
5Step 5: Validate with a debug run and confirm the activity executes without the type error.

Frequently asked questions

How do I convert a string parameter to an integer in a Fabric pipeline expression?

Use the int() function in your dynamic content expression, for example: @int(pipeline().parameters.myParam). This explicitly converts the string value to an integer before it is passed to the property.

Is Error 2111 the same as Error 2106?

No. Error 2106 relates specifically to an invalid storage connection string. Error 2111 is a general property type mismatch that can affect any activity property across different connector and activity types.