Auto Binding Feature Not Working with Deployment Pipelines

Hi, Anonymous 

To troubleshoot your issue, follow these steps:

1. Check Workspace Configuration: Verify that all workspaces are in the Power BI Service (not in Power BI Desktop) and they have been created using the "new workspace experience". Also ensure that you have proper permissions in all workspaces.

2. Examine Deployment Rules: Validate all deployment rules to ensure that they are correct. As you have mentioned, they should change the data source connection from Test to Prod.

3. Validate Dataflow Connection: Check your dataset's connection to the dataflow. Sometimes, if the dataset is not correctly connected to the dataflow, it might still be pointing to the old one even after deployment.

4. Check Dataset Configuration: Make sure your datasets are using parameters for dataflow and other sources. This allows the pipeline to change the sources when deploying between stages.

5. Manually Update: If all else fails, manually updating the dataflow references in the deployed dataset can be a workaround, though it shouldn't be necessary.

This should help identify any issues with the deployment process.