Skip to main content



No record found.

Dynamics 365 general forum

Azure Synapse Link for Dataverse pipeline

Posted on by 30
We have a situation where a previously running correctly Azure Synapse Link for Dataverse configuration was removed.
In trying to re-establish this configuration, we are following our documentation that was used to establish this in the first place, and even allowing for the updated Microsoft documentation that suggests that Azure Synapse Pipelines need to use trigger().outputs.body.folderPath expression instead of what we previously used as triggerBody().folderPath to obtain the container and folder values for the file triggering the pipeline.
In trying this we are encountering a "filesystem does not match expected pattern" error with values in the error message for FileSystem and Folder path that look like the literal values of the expressions that are specified in the pipeline Trigger Run Parameters.  So it doesn't look like the expressions are being evaluated.  We have tested this further by specifying Default values for the parameters, which also look like expressions are not being evaluated.
So my question is. do Parameters Default Values support expressions?  Is there a way we can examine what the values being assigned to the "container" and "folder" parameters of the DataverseToSQL pipeline at run-time?

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .


André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

nmaenpaa Profile Picture

nmaenpaa 101,148


Featured topics

Product updates

Dynamics 365 release plans