Azure Data Factory - Passing parameters (pipeline details) into Dataflow - error

Robert 1 Reputation point
2021-05-04T12:08:08.737+00:00

When passing in two parameters which equate to @pipeline.RunId and @pipeline.RunDateTime into a DF, I get the error below. I've checked the expression box on the Parameters both on/off - same error. I want to append these values to my data.
When using debug within the data flow, the debug picture of the data is correct with the values set in the debug window. The problem appears to be with the @pipeline.RunId paramrter

Operation on target LoadHubsToStagingDF failed: {"StatusCode":"DF-Executor-ParseError","Message":"Job failed due to reason: Expression cannot be parsed","Details":"Parameter stream has parsing errors\nLine 2 Position 36: missing '=' at ':'\nLine 2 Position 37: mismatched input '44' expecting {'parameters', 'functions', 'as', 'input', 'output', 'constant', 'expression', 'integer', 'short', 'long', 'double', 'float', 'decimal', 'boolean', 'timestamp', 'date', 'byte', 'binary', 'integral', 'number', 'fractional', 'any', IDENTIFIER, ANY_IDENTIFIER}\nLine 3 Position 0: extraneous input 'ip_PipelineRunId' expecting '='"}

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,108 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Robert 1 Reputation point
    2021-05-05T16:24:09.833+00:00

    Hi Himanshu - I managed to sort out my problem. I just need to read the following guidance 3 times - the issue was with the timestamps!
    https://learn.microsoft.com/en-us/azure/data-factory/parameters-data-flow
    Thanks