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 🙂
I tried this and it worked to allow me to connecto to a different environment and launch the Power Automate, however it did not pass any of the variable I had selected to the Power Automate but instead shows this for the body:
"body": {"entity": {"Power BI values": []}}Hi,
My case it's only a trigger with no variables. I would recomend to check if there is more instance of enviroment and flow URL and replace it as well. Also you can try to create a Automate Flow on the standard enviroment and in the different enviroment, and proceed with the steps above to migrate from one to another, but I'm not sure that it will work, you have to try...
Best regards.
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.
Thanks for the solution, it works properly for myself. However, my colleague is still directed to the default environment when they open the same report and click the same button. Can this solution be applied the same to other users as well?
Hi,
It sounds weird for me. Just a obivous question, have you update the App after doing it? This is a visual settings change and if you don't update the App it will keep previous version on it.
If you did I expect that it will work exactly in same way for all users, if not, could be the case that this user don't have access to this specific environment.
Best regards.
I am sorry but what do you mean by saying 'update the App' ? I saved the report after I changed environment id from default to another one. But when I open the report and go into edit mode of the power automate button, it shows the same old power automate flow that exists in the default enviroment as if nothing was changed. Interesting fact is that the button is working perfect using a new flow in another environment even though it appears connected to the previous flow in the default enviroment. 😅
BTW don't forget to give a 👍
