'Select an Environment' option in Power Automate Visual via Desktop is missing

[mellieb]

Hi All,

We need the ability to 'Select an Environment' option in the Power Automate Visual in Power BI desktop but it seems to be missing or it is not there or as described in the MS article Create a Power Automate visual for Power BI - Power BI | Microsoft Learn.

I tried both February 2024 and March 2024 version but it is not there. Is there a certain setting in Power BI Desktop or maybe Power BI Automate that enables this option?  The first screenshot is from the microsoft documentation showing the 'Select an Environment' option...

In Power BI desktop the 'Select environment' is not showing or displaying...

[mellieb]

I full admin access to all environments and I still do not see it.  

[mellieb]

I have access to several environments in Power Automate using my profile/login account and still do not see this option in Desktop.  The login in Desktop and Automate should be the same.  

[TDai_Arrotex]

I found a workaround from another user on this forum

mpaixao 

Advocate I

‎02-09-2023 01:39 AM

Hi,

I found a solution. 

Step 1 - get the "ID" of 2nd environment(the one that is not default), basically when you select it on the Power Automate page your URL will look like this https://make.powerautomate.com/environments/xxxxxx-xxxxx-xxxx-xxxxx-xxxxxxxxxx/flows

Step 2 - Open the Power BI Report at Edit mode on browser (it will not work on Power BI Desktop)

Step 3 - Go to the trigger of Power Automate inside of report and Edit, it will show you the list of flows on default environment. 

Step 4 - Right click and "Inspect" to see the source code of the page, search for "Environment", in my case it's the 5th ocurrence. It's a iframe with a long address.

It starts with:
https://xxxxx.flow.microsoft.com/en-US/widgets/manage/environments/Default-yyyyyy-yyyy-yyyy-yyyy-yyyyyyyyyy/flows?.....

Step 5 - Change the the part between "environments/" and "/flows" to the 2nd environment (got on Step1). It will refresh the iframe automatically and then you will see the list of flows on 2nd environment.

TESTED ON EDGE, I believe it works for Chrome and others.

If works for you give me a LIKE 

[TDai_Arrotex]

I am having the exact same issue, this is very frustrating i think the newest version of PowerBI broke some things.

[amitchandak]

@mellieb , I think that is based on your login in the Power BI desktop. Based on that it will pull the environment you have access to power automate. If you only have one. The first step will be skipped.