I am trying to refresh dataflows using the rest api: https://docs.microsoft.com/en-us/rest/api/power-bi/dataflows/refreshdataflow
And I am getting the following error:
Invoke-RestMethod : The remote server returned an error: (400) Bad Request.At line:2 char:1+ Invoke-RestMethod -Uri $uri –Headers $authHeader –Method POST –Verbos ...+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+ CategoryInfo : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMethod], WebException+ FullyQualifiedErrorId : WebCmdletWebResponseException,Microsoft.PowerShell.Commands.InvokeRestMethodCommand
I am not sure is this a bug or not though, I can get dataflow list using same authenticaiton.
Anyone have ideas on this issue?
Hi @SimonL7 ,
You need to pass "refreshRequest": "y" in your request body. For more information, please refer to this thread: https://community.powerbi.com/t5/Developer/Power-BI-API-Dataflow-Refresh-Operation/td-p/588556
Best Regards,Qiuyun Yu
I am getting the same error. I am refreshing a dataflow via Power Automate. It works fine for several refreshes. Then it just seems to randomly "break" with error
The backend request failed with error code '400'
I also tried this on my co-workers cloud and had the same results.
My dataflow does have a web call in it. But why would it work and then break?
I get the same error since 07-SepI exported the DS to a new WSAfter successful execution, it randomly breaks throwing The backend request failed with error code '400'
Please, it is important to solve the problem because it depends on the intervention to end the flows
I m having the same error when I try to trigger a Dataflow refresh via PowerAutomateAction 'Refresh_a_dataflow' failedThe backend request failed with error code '400'Its very random and there is no addiotnal information to debug. Anyone you can help here?All the below failed status are due to the same reason :
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.