Dataflow query in desktop do not obey parameters set values

Hi FireFighter1017 ,

Thanks for reaching out to the Microsoft fabric community forum.

Power BI Desktop may cache previous connection info from the PowerPlatform.Dataflows() connector, so even if you update parameters, it might still use old PROD details from connections.json. This can make parameter changes seem ineffective.

Try These steps:

1. Clear Data Source Settings in Desktop:
Go to File - Options and Settings - Data Source Settings.
Clear permissions for Power Platform and remove cached connections.

2. Inspect PBIP Files in Git:
Check parameters.json – confirm the right values are set.
Check connections.json – this may have hardcoded workspace/dataflow IDs that override parameters.

3. Regenerate PBIP Cleanly:
Try opening a clean .pbix (not from PBIP), and test parameters for DEV.
Once confirmed working, export it as PBIP again.
Compare the new connections.json with your repo version.

4. Consider Switching to OData.Feed():
Instead of using PowerPlatform.Dataflows(), try:

let
url = "https://api.powerbi.com/powerbi/globaldataflows/v1.0/myorg/groups/" & WS_WORKSPACE_NAME & "/dataflows/" & DF_DATAFLOW_NAME,
data = OData.Feed(url)
in
data

This gives full control over the connection URI and respects parameters reliably.

The issue is most likely caused by how PowerPlatform.Dataflows() behaves in PBIP projects it's not always reactive to parameter changes due to caching and metadata binding. Using OData.Feed() or cleaning out connections.json may help regain control.

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