How to control Power BI deployment pipelines with embedded Power Apps and Power Automate Flows

[speedramps]

Please only add comments if you know the answer. It is a bit annoying when helpers wild guess because it can discourage other helpers from answering correctly. Thank you.  

Consider this scenario ...

Create three backend databases (dev, test and prod)

Create three Power BI premium workspaces (dev, test and prod)  and a deploymement pipeline with rules to use the corresponding backend database.

Publish a Power BI semantic data model and report to dev workspaces with datasource = dev database

Use the deployment pipeline to promote a semantic datamodel and report from dev to test and prod workspace. The deploymet pipeline rules automatically kicks in and changes the data source. All good so far !

Now create a Power App in the dev, test and prod "environment" linked to the dev, test and prod databases.
Note that "environments" are different containers to "workspaces".

Embeded the dev Power App in the Power Bi report in the dev workspace.

When you promote the Power Bi report from dev to test and prod then obviously you want the embeded logic to automatically use the Power App in the corresponding environment.  You dont want the test and prod reports still connected to the embeded dev Power App.

Can the Power BI deployment rules include the environment rules for embeded Power App? If so how?
Or is there another easy way without converting to GITHUB.

(We plan to use GITHUB in future but looking for native solution right now)

The same issue applied to Power Apps and Power Automate.

Thank you

[speedramps]

@Anonymous thank you 👍

[Anonymous · Accepted solution]

Hi @speedramps,

Currently, the Power BI deployment pipeline does not automatically switch the embedded Power Apps environment.

As seen in similar questions:

The best workaround is to have all three apps on the report page and show/hide the appropriate one on each workspace. You need to edit the report, show selection pane in the view tab and show the right app after each deplyoment. Unfortunatelly you have to do it everytime and the deployment pipeline looks broken as the reports don't match after the change.

Reference:

Deployment Pipeline of Report with Embedded PowerA... - Microsoft Fabric Community

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.