Changing the Environment of a Power Apps visual using Parameters

[JordanImran]

Hi,

I'm using the Power Apps visual for Power BI. I have Dev, Test, UAT/Staging and Production Environments setup for both apps and BI.

Can anyone shed light on how to create a parameterised PBIT file that can change the Power Apps environment in step with the Report itself?

Ideally I'd like:

File	mydash.pbit
Env (PBI)	Dev	Test	Staging	Prod
Env (PowerApps)	Dev	Test	Staging	Prod

Where mydash.pbit is the single file.

[Devale1]

You can remove the fields from the powerapp, go to general pane, and click reset.  Then,  re-add the fields and you can select the powerapp.

Another option:

Use the pbir format and change the appid in the visual.json to the app of the other powerapp

This does require pbir which is in preview and currently has some limitations. 

To find the appid, play the app in the browser and look in the url after /a/

[Anonymous]

Hi,

Did you get anywhere with this in the last few years, @JordanImran? I have just come across the same challenge and have posted in the Power Apps community here.

Thanks.

[Eland209]

Hi,

I encountered the same issue and found a work around. 

In power bi desktop: Change the Power Bi visual to a table, leaving all datafields. Save and close the report. 

Reopen the report and change the table visual back to power apps. The visual will now ask to select an environment and then an app. In these steps you can select your new environment and app. 

[luca_di_odoardo]

HI Eland209,

do u have find another solutions to Changing the Environment of a Power Apps?

[Eland209]

@luca_di_odoardo , Unfortunately not.

[v-zhenbw-msft]

Hi @JordanImran ,

Do you want to create a table visual and put a file in it?

If yes, sorry for that power BI cannot achieve this.

Maybe you can upload your files to OneDrive For Business and copy the link based on Enter Data function, or create a Text box and insert the link.

If it doesn’t meet your requirement, perhaps you can submit the requirement to ideas and add your comments there to make this feature coming sooner : https://ideas.powerbi.com/forums/265200-power-bi-ideas

Or you can try to find a solution in the power Apps forum.

Best regards,

Community Support Team _ zhenbw

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

[JordanImran]

Not exactly - I'm looking to build a single Power BI Template File, and move it between Development and Test Environments.

When I move the dashboard using DevOps, I can adjust SQL connection strings without modifying the dashboard. For example:

1. Create .pbit file with parameter "Connection String" in the Power query data source settings
2. Upon loading the Dashboard in a new environment, use PowerShell to set the parameters of the connection string like below:

Dev Connection String: user=mynamedev;pwd=mypassdev;db=mydbdev

Test Connection String: user=mynametest;pwd=mypasstest;db=mydbtest

Advantage is I have ONE .pbit file to manage.

I have a Power Apps for Power BI visual in my dashboard. However I can only change the environment to which it is connected by :

1. deleting the visual
2. re-adding the visual
3. connecting to my test environment and selecting the test version of the app

My question is: Is there a way to change the PowerApps connections (for Power BI) using parameters, as we would for SQL connection strings?

Thanks

[v-zhenbw-msft]

Hi @JordanImran ,

Maybe you can refer this article. Hope it helps.

https://www.howtoexcel.org/power-bi/integrating-power-bi-and-powerapps/

Best regards,

Community Support Team _ zhenbw

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

[JordanImran]

Doesn't help I'm afraid - more of an entry level guide.

I'll mark 'not possible' as the solution and get an idea patched to MSFT

Cheers all

[Greg_Deckler]

@JordanImran - I'm not aware of any way to do that.