Microsoft Fabric: Integration with ADO Repos and Deployment Pipelines - A Power BI Case Study.

Thank John_Britto for your comment.

We suggest keeping a solution's Lakehouse in a Main Workspace, where all developers use their data pipelines, experiments, copies of data sources, etc. in separate workspaces, but all connecting to the same Main Lakehouse.

Then that Main Workspace must be deployed to TEST and PROD.

When deployments occur, be sure to refresh the data in the Lakehouse in TEST and PROD, rerunning the data pipelines that were deployed in TEST and PROD.

You can change the sources of the copy data activities in data pipelines occasionally in TEST, to use test data when you want to test the solution in TEST, which does not impact the Production sources if you deploy from TEST to PROD several times.

You can use other workarounds too.

It is a great pleasure to us to answer any question or concern.