This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now
Updating the Mashup.pq is actually something that would trigger a commit and not something that we would recommend as it woudl be considered a change between the Dataflow that you have across workspaces.
Fundamentally, you want the same Dataflow definition across all environments, but they should have the right context as to what items they should be getting the data from OR loading the data to.
The article below explains in detail with tutorials how you can set the best solution architectures with a Fabric deployment pipeline in mind:
CI/CD and ALM solution architectures for Dataflow Gen2 - Microsoft Fabric | Microsoft Learn
Do feel free to post any other ideas if you think that there's any functionality that should be extended or improved on