Forum Discussion
Reverting from Prod back to Dev, when you have Data Source Rules
This behavior occurs because Power BI deployment pipelines apply deployment rules strictly as a one-way filter during forward deployments (Dev to Test to Prod), meaning the rule engine does not automatically intercept or rewrite data source connections when you execute a backward deployment (Prod to Dev). To revert your development dataset back to your dev data sources without breaking your pipeline links, the community-recommended best practice is to avoid manual desktop republishing and instead use a parameterized architecture coupled with manual workspace overriding. Go into Power BI Desktop, convert your hardcoded server and database strings into explicit Power Query Text Parameters (e.g., ServerName and DBName), and republish the model to establish a clean foundation. Now, whenever you must pull an asset backward from Prod to Dev, simply complete the deployment inside the pipeline, immediately navigate to the Semantic Model Settings directly within your Cloud Development Workspace, expand the Parameters section, manually type your development database server credentials into the parameter boxes, click Apply, and then re-authenticate your connection details under the Data source credentials section to instantly force the Dev environment back to dev data.