How to easily switch a power app that is embedded in a power bi report from power app environment DE

[Anonymous]

I have created a power bi report with an embedded power app. As I am developing the report, the power app resides on a development environment. When the report is finished I have to copy (export/import solution) the power app to a production environment. And this is where the problem starts as now the embedded power app needs to refer to the production environment instead of the development one.

The only solution I found is to delete the power app from the report, add a new power app, link it to the existing app in the production environment... and set all the visual properties (size, title, color...) of the power app visual again.

A painful process... 

How to easily switch an embedded power app in my power bi report from the development to the production environment?

Is there no way to just edit the URL of the embedded app somewhere (via a tool)?

Thanks

[veikko]

If anyone is still wondering about this, there is now a solution.

You can use the "Reset to default" option in the visual's settings. This keeps the fields, but allows you to select a different Power App.

[Lukazy]

@Anonymous 

Ah, I recently came across the same problem. You can solve this by saving the power BI report not as pbix but as pbip, i.e., as project. This is quite new feature and allows you to have the Power BI report in more or less human readable shape. It will create a folder named <ReportName>.Report, where you will find a report.json file. It contains information about all the visuals of your report. It will also contain a line with your embedded power App. 

It looks something like: '/providers/Microsoft.PowerApps/apps/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx'. The number will match the unique identifier of your power app. You can find it in the Power Apps environment if you navigate to some detail panel.

All you have to do is replace all occurrences of your Development Power App identifiert with the one of the production. Then reload the report and it should work.

[Anonymous]

Actually just renaming it to .zip, unzipping, rezipping and renaming to .pbix (without doing any changes) already gives an error when trying  to open it in PBI desktop 😞

[lbendlin]

Use 7zip

[Anonymous]

Thanks for you answer, I thought that would be an option.
I unzipped the PBIX and used visual studio to search on 'powerapp', see picture.

So I just need to replace the App ID and zip everything again or is there some extra catch I need to take care off?
Also, is there some tool that you could recommend to do this? I am a layman with Visual studio...
Thanks again for any furhter advise.

[lbendlin]

If the PBIP includes the visual definitions then you can try that one instead.

As you can likely appreciate patching the PBIX is wholly unsupported and done at your own risk. Always have a backup.

[lbendlin]

You can patch the URL inside the PBIX file (it's an archive with a bunch of JSON files etc, and one of them contains the definition of the visuals). However this would not fall under the "Easily"  category.

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41