Dataflow Gen2 parameter works with current value but fails when passed from Fabric Pipeline

Hi, that error usually means a step is trying to pick an item from an empty result. So most likely the API returned an error or empty response, which means the value reaching the dataflow isn't the same as your current value.

Few things to check:
1. Public parameter mode is enabled and the dataflow is saved.
2. In the pipeline Dataflow activity, refresh the parameters list and check the name matches exactly (case sensitive).
3. Pipeline expressions often add quotes or a trailing space. Try Text.Trim(Text.From(APIKey)).
4. To confirm what arrived, write Text.Length(APIKey) to a small debug table and compare with the real key length.

Let me know what you find.