Hi Community,
We have created PowerBI report that is embedded on a main form of Model driven app. 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?
Hi Anureet,
You can follow below steps.
//unfilteredreport is the name of PBI report control formContext.getControl("unfilteredreport").controlDescriptor.Parameters["PowerBIGroupId"]="28fd43c-b901-4629-b3dd-923a783863ef"; formContext.getControl("unfilteredreport").controlDescriptor.Parameters["PowerBIReportId"]="da4730ef-da58-48ce-bcd4-4ea4ef45307d"; formContext.getControl("unfilteredreport").controlDescriptor.Parameters["TileUrl"]="https://app.powerbi.com/reportEmbed?reportId=da4730ef-da58-48ce-bcd4-4ea4ef45307d"; formContext.getControl("unfilteredreport").setVisible(true);
Note : hide the report control by default on the form and show only after setting environment specific values
Thanks,
Ketan
Hi,
I would suggest to post the question in below forum:
https://community.powerbi.com/t5/Forums/ct-p/PBI_Comm_Forums
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,867 Super User 2024 Season 2
Martin Dráb 229,173 Most Valuable Professional
nmaenpaa 101,156