Dataflow query in desktop do not obey parameters set values

Hi FireFighter1017 ,

Thanks for reaching out to the Microsoft fabric community forum.

This issue occurs because Power BI deployment pipelines automatically override dataset parameters according to the rules set in the environment configuration.

Therefore, even if you update the parameter in Power BI Desktop or manually republish with DEV/QA values,

the deployment pipeline will still replace the parameter values with those configured for the current environment, which in your case seems to be PROD.

Review and Update Deployment Pipeline Parameter Rules

In Power BI Service, go to the deployment pipeline containing your dataset.
Navigate to the relevant environment (such as QA or DEV).
In Deployment Settings, check the Parameter rules.
You may find parameters like WS_WORKSPACE_NAME and DF_DATAFLOW_NAME set to PROD values.
Update them to the correct DEV/QA values for that environment and save your changes.

Disable Parameter Override (Optional)

If you want to prevent deployment pipelines from overriding your parameters, uncheck "Override during deployment" for each parameter in Deployment Settings.

However, it is generally recommended to configure parameters correctly for each environment rather than disabling overrides.

Additional Validation

To test in Power BI Desktop, set the parameter to a QA/DEV value and verify that the query editor preview uses the correct data source. After publishing to a specific workspace, check the parameter values in the dataset settings. If using a pipeline, ensure it is not overriding these values during deployment.

Following these steps will help make sure your workspace and dataflow IDs are set correctly for each environment and that parameters work as intended.

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it

Best Regards,
Sreeteja.
Community Support Team