Azure Data Factory - Error creating a parameterised mapping dataflow

user_13073444 0
Viewed 1876

I am having an error when trying to create a parameterised Mapping Data Flow. More specifically, I have the following error. Anyone have suggestions on how to fix it or what the error may be? 

{ "Message": "ErrorCode=InvalidTemplate, ErrorMessage=Unable to parse expression 'body('DataFlowDebugExpressionResolver')?.Data Vault Loadb734571b6d5a414ea8387a08077f1ff1?.DataVaultSource.sourcetable': expected token 'EndOfData' and actual 'Identifier'." } - RunId: 24ee9884-610d-4061-a9be-670aeb8f1660

Thanks @Leon and @Joel for your responses. I am attaching my pipelines here for your consideration

[Data Source connection with Parameter. I can preview data with no errors1

Error caused in the data flow when trying to debug or run the mapping data for (Runtime Error)

azure-data-factory
2 Answers

I have found the resolution to the problem I raised yesterday. The error was caused by the name of the Mapping Data Flow (Data Vault Load).

I raised a request from Microsoft and they had the following suggestion

Spaces in name of object and parameters does not go well

Once I removed the spaces in my Mapping Data Flow name it, this particular error was resolved.

Fixed Error by removing spaces in the name

Thanks to everyone that responded.

user_130734440

I have been looking for going around looking for this answer it is 2021 and Microsoft still didn't add any validation or restriction for the naming of the Data Flow

user_69063070
Related