I was following this article to push data from Power BI to Flow using web.contents function: https://www.thebiccountant.com/2019/04/01/export-data-from-power-bi-using-microsoft-flow/
The flow is receiving the data and I can process it. However as soon as I add a step like send email, create file, etc. (i.e. some step, that would push the data outside the flow again), I get an error message in Power BI (bad request) and my Flow is getting marked with an error message ("Problem with the trigger of the flow", saying bad request).
Not working when adding "send email" or something similar:
I tried with different data source tables, tried to rebuild the flow, deleted everything but the trigger and the step "send email", but I always end up with an error as soon as I add that step.
Also, If I push the data from Power BI to Flow without the step "send email" (which is succeeding) and afterwards add the step "send email" and restart the flow with the data received before, it will work send out the email...
Does anybody have an idea what is wrong with the flow?
Are you using any property or parameter from the trigger within email action or variables?
I'm having the same issue except with Add Rows excel connector.
The Flow works without the Excel Connector.
Once the Excel step is added, it will only work if I test my Flow with a previous successful run. It will work with or without variables in there.
If I run it manually with the Excel step added, I get a generic error saying "Bad Request". No reason why its bad or how to fix it. It also then says that there is a problem with my trigger. When I click Learn More, it is just generic troubleshooting that does not have any steps for When a HTTP Request is Received. This will also fail if I take out the parameters in the Add Row step. Any thoughts?
This worked when I ran a test flow with a previous successful run:
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us on June 28 for our monthly User Group leader call!
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!