Forum Discussion
Power Automate Environment / Power BI
Microsoft just announced an update to the Power Automate visual and the functionality to choose environment is now there: https://powerbi.microsoft.com/en-us/blog/power-automate-visual-ga-embed-workflows-directly-within-your-power-bi-reports/
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 🙂
Big thanks, this was a lifesaver for me.
However this worked a month ago, and now I'm getting "unsuccessful" when I click on the Power Automate button. Anyone in a similar space?
hi, I was in the same situation and solved the issue after going around posts and solutions.
The solution is to go with the evivronment selection provided in Power BI Service,
I just rebuilt the button and added fields on Power BI Service, still not able to change environment in Desktop.