Dataflow Parameters not resolving when created from New Query

[adamlob]

Trying to create multiple paramaters for workspace/warehouse GUIDs in a dataflow. 

When trying to create a paramater by selecting New Query and typing the parameter details I get the following error when trying to run the pipeline. 

The dataflow view works fine and the table resolves.

Parameters only work when creating them new under 'Manage Parameters.'

[v-menakakota · Accepted solution]

Hi @adamlob ,

Thank you for contacting the Microsoft Fabric community forum.

Microsoft documentation describes Dataflow Gen2 parameters as values created and managed through the Manage Parameters experience in Power Query. These parameters support configurable input scenarios and include metadata such as data type, required configuration, and suggested values.

Queries created through New Query are standard Power Query queries and are not documented as Dataflow parameter objects.

As a supported approach, Microsoft documentation recommends using the parameter management experience when implementing parameterized Dataflow scenarios.

Please go through the below documents for the reference:

Use public parameters in Dataflow Gen2 – Microsoft Fabric

Parameters in Power Query (Microsoft Learn) 
Parameterized Dataflow Gen2 – Microsoft Fabric

If I misunderstand your needs or you still have problems on it, please feel free to let us know. 

Best Regards, 
Community Support Team

[v-menakakota]

Hi @adamlob ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

Best Regards, 
Community Support Team