Forum Discussion
Solved
Dataflow Gen2 (CI/CD) Data Pipeline Activity Fails when Dynamic Parameters Passed from Data Pipeline
Hi Fellow Fabricators, This one gave me a nasty headache, so I'm posting here to help others with the same issue. Error code: 20302 Failure type: User configuration issue Details Dataflo...
- SOLUTION: Parameter data types must align in DFG2 & DPLAfter a lot of config tweaking to identify the root cause, it was a simple data typing issue (of course!!).Parameters in data pipeline items must be strongly typed - mine were of type [String]The DFG2 parameters were of type Any - this is usually really forgiving.By changing the data type of all parameters in DFG2 to [Text] the DPL activity ran perfectly.NOTES:
- The error could be much more meaningful - and indeed the documentation should be updated to make this data type match requirement clear.
- Dataflows and Data Pipelines have different development stories:
- Dataflows have evolved considerably since their origin in Excel Power Query (aka Data Explorer)
- Fabric data pipelines began life in Azure Data Factory - with some Azure Synapse pipeline DNA.
- It is clear that these Fabric items are still not fully consistent - not least because types String and Text are not interchangeable/identical at a technical level : p
SOLUTION: Parameter data types must align in DFG2 & DPL
After a lot of config tweaking to identify the root cause, it was a simple data typing issue (of course!!).
Parameters in data pipeline items must be strongly typed - mine were of type [String]
The DFG2 parameters were of type Any - this is usually really forgiving.
By changing the data type of all parameters in DFG2 to [Text] the DPL activity ran perfectly.
NOTES:
- The error could be much more meaningful - and indeed the documentation should be updated to make this data type match requirement clear.
- Dataflows and Data Pipelines have different development stories:
- Dataflows have evolved considerably since their origin in Excel Power Query (aka Data Explorer)
- Fabric data pipelines began life in Azure Data Factory - with some Azure Synapse pipeline DNA.
- It is clear that these Fabric items are still not fully consistent - not least because types String and Text are not interchangeable/identical at a technical level : p