Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Azure Data Factory - Error creating a parameterised mapping dataflow

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)

like image 473
Sarath Avatar asked Jul 16 '26 02:07

Sarath


1 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.

like image 80
Sarath Avatar answered Jul 21 '26 03:07

Sarath



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!