Forum Discussion
Power Automate Environment / Power BI
When importing the Power Automate for Power BI visual I only get flows, or can create flows, in the default power automate environment. Is it possible to get flows from a non-default environment using this visual?
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/
30 Replies
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 have this issue as well. We have many flows in a specific Power Platform enviornment. The connector visual in Power BI seemingly has no way to change the enviorment it is looking at. This prevents us from using any of the Flows in those enviornments.
Did anyone find a solution for this?
I ended up embedding an Power App, and trigger the flow throug the Power App. Not sure if there are any new capabilities introduced the last months that lets you choose flows from another environment
Even I have faced the same issue. From power automate it will redirect to default envirnoment. I'm just wondering how to change the envirnoment from power bi desktop.
Hi,
It's 17th August 2022 and I have done research still no solution to this. Can someone please share the solution if any.
Regards,
Amit Kumar Rath
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/
This change is a huge improvement. Two issues I'm still seeing:
1. Once you apply a flow to a button in your PBI report - when you go back to edit the flow (via PBI), the list of flows shown are just the default environment. Not sure if if this is happening to others - but it essentially requires me to delete the button, start over, select the different environment and then make edits.2. It would be great if Microsoft would update it so that once you apply a flow to a button that it indicates which flow is applied.
Hi bjorneev
What is a non-default environment that mentioned by you ?
In the edit mode of the visual, you can select an existing flow to be applied to the button, or create a new flow to be applied to the button. You can start from scratch, or you can start from a built-in template as an example. To start from scratch, select New>Instant Cloud Stream .
Detail operations can refer to the link below .
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-automate-visual
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This post explains the current situation but does not address this thread topic. We have restrictions in place on connectors within the default envionment, preventing users from creating unauthorised Flows, therefore have created new environments for Software to use for UAT and Production with less restrictions (allowing use of connectors that cannot be used by regular users).
Creating in a default environment does not allow use of any blocked connectors and we have less oversight of active solutions with some having to reside in default and others in Production. This is not an enterprise solution and we will therefore be looking at alternative software until this is addressed.You can create/edit flows yes, but you cannot choose which environment you are creating/retrieving your flows from as far as I can tell. For example, we have three Power Platform environments available. But in Power BI only flows from one of the environments (the default, or first one created) shows up.
But what if I already have a flow created in a different environment in power automate ?
I'm having the same issue here. Did anyone get a solution for this?
No, not for getting flows from another environments. I circumvented this by embedding a Power App in the report instead to pass the data and trigger a flow in the correct environment.
Currently, you cannot change the Power Automate environment. There is an idea that you can go upvote to add this functionality. Please see this link: https://ideas.powerbi.com/ideas/idea/?ideaid=04e32a46-56b6-ec11-bea2-281878e63983
Any solution for this yet ?
