We have created PowerBI report that is embedded on a main form of Model driven app (PowerPlatform/MS Dynamics). This report is contextually filtered based on the record it is opened from.
We have followed this MS doc to embed(this involves editing the customization.xml file to add parameters like reportID , groupId, filter,titleUrl):
We have three different workspace setup DEV -> UAT -> PROD hence the reportId and groupId and other parameters differ for each workspace.
PAINPOINT :Each time when the form containing the embedded PowerBI report has to be promoted to higher environment in dynamics , these report parameters have to be edited in customisation.xml as per the environment it is getting promoted to.
Is there a cleaner approach to handle this situation?