What causes Fabric Pipeline Error 2105?

A JSON string passed to a property has syntax errors such as missing quotes, brackets, or commas. A pipeline parameter or expression intended to produce JSON resolves to an invalid or incomplete JSON string at runtime. Manual edits to the pipeline JSON payload introduced malformed JSON in a property value. A dynamic content expression (e.g., using @concat or @variables) builds an incorrectly structured JSON string

How do I fix Fabric Pipeline Error 2105?

Step 1: Identify the property name ('%propertyName;') from the error message to locate the field containing the invalid JSON.. Step 2: Extract the current value of the property — either from the pipeline authoring canvas or from the pipeline JSON view — and paste it into a JSON validator tool (e.g., jsonlint.com or VS Code) to identify the syntax error.. Step 3: Correct the JSON syntax error in the property value, ensuring all brackets, quotes, and commas are properly balanced and formatted.. Step 4: If the JSON value is dynamically constructed via a Fabric expression, test the expression output using the pipeline debug feature to confirm it produces valid JSON before running the full pipeline.. Step 5: Save the corrected pipeline, run the built-in validation, and re-execute to confirm the error is resolved.

Medium severitydata formatMicrosoft Fabric →

Power BI Refresh Error:
Fabric Pipeline Error 2105

What does this error mean?

A pipeline property expected a valid JSON value, but the provided value is malformed or unparseable JSON. The pipeline cannot execute until the property contains syntactically correct JSON.

Common causes

1A JSON string passed to a property has syntax errors such as missing quotes, brackets, or commas
2A pipeline parameter or expression intended to produce JSON resolves to an invalid or incomplete JSON string at runtime
3Manual edits to the pipeline JSON payload introduced malformed JSON in a property value
4A dynamic content expression (e.g., using @concat or @variables) builds an incorrectly structured JSON string

How to fix it

1Step 1: Identify the property name ('%propertyName;') from the error message to locate the field containing the invalid JSON.
2Step 2: Extract the current value of the property — either from the pipeline authoring canvas or from the pipeline JSON view — and paste it into a JSON validator tool (e.g., jsonlint.com or VS Code) to identify the syntax error.
3Step 3: Correct the JSON syntax error in the property value, ensuring all brackets, quotes, and commas are properly balanced and formatted.
4Step 4: If the JSON value is dynamically constructed via a Fabric expression, test the expression output using the pipeline debug feature to confirm it produces valid JSON before running the full pipeline.
5Step 5: Save the corrected pipeline, run the built-in validation, and re-execute to confirm the error is resolved.

Frequently asked questions

How do I debug a dynamic expression that produces invalid JSON in Fabric pipelines?

Use the Fabric pipeline Debug mode and add a Set Variable or Web activity to capture and inspect the output of the expression producing the JSON. Compare the actual output against expected JSON structure to identify where the expression logic is generating invalid syntax.

Are escaped characters a common cause of Error 2105?

Yes. When JSON strings are embedded within other JSON or expression strings, escape characters (e.g., backslashes, escaped quotes) are a frequent source of malformed JSON. Carefully review how quotes and special characters are escaped within the property value.