Power BI Refresh Error:
Fabric Pipeline Error 2106
What does this error mean?
The storage connection string provided in the pipeline connection is invalid or incorrectly formatted. The pipeline cannot establish a connection to the target storage resource.
Common causes
- 1Connection string was manually typed or partially copied, introducing syntax errors
- 2Storage account key has been regenerated, making the existing connection string stale
- 3Connection string is using an incorrect format for the target storage type (e.g., mixing Azure Data Lake and Blob Storage formats)
- 4Placeholder or template variables were left unreplaced in the connection string
How to fix it
- 1Step 1: Navigate to the Azure Portal and open the target Storage Account.
- 2Step 2: Go to 'Security + networking' > 'Access keys' and copy the full connection string from either key1 or key2.
- 3Step 3: Open the Fabric Data Factory pipeline, locate the affected linked service or connection, and replace the existing connection string with the one copied from the portal.
- 4Step 4: Test the connection using the 'Test connection' button before saving.
- 5Step 5: Re-run the pipeline and verify the activity succeeds.