Power Automate - Using Flows

Unanswered

Refresh dataflow fails with error code '400'

Like (1) Share

Report

Posted on 17 Feb 2022 12:32:51 by RvAntwerpen

Hello,

I've set up a simple flow (see image below) with which I want to refresh a dataflow. However, after working once, it keeps throwing the following error:

The backend request failed with error code '400'

Does anyone have any idea what's going wrong here? The strangest thing is that it has worked twice since I set it up, but it has failed all the other times (+/- 20 times). The errorcode doesn't give me much to work with either. I have included the output that is returned below. The account that I am using to kick off the flow has a Power BI premium per user license.

Thank you very much for the replies.

{

"statusCode": 400,

"headers": {

"Pragma": "no-cache",

"Strict-Transport-Security": "max-age=31536000; includeSubDomains",

"X-Frame-Options": "deny",

"X-Content-Type-Options": "nosniff",

"RequestId": "6a571705-9579-485c-a090-a6093912b318",

"Access-Control-Expose-Headers": "RequestId",

"request-redirected": "true",

"home-cluster-uri": "https://wabi-north-europe-l-primary-redirect.analysis.windows.net/",

"Timing-Allow-Origin": "*",

"x-ms-apihub-cached-response": "false",

"x-ms-apihub-obo": "true",

"Cache-Control": "no-store, must-revalidate, no-cache",

"Date": "Thu, 17 Feb 2022 12:20:01 GMT",

"Content-Length": "518",

"Content-Type": "application/json"

"body": {

"Message": "The backend request failed with error code '400'",

"Reason": "Bad Request",

"WorkspaceType": "Workspace",

"OperationId": "RefreshDataflow",

"ClientRequestId": "3eac4afb-0486-4e18-a281-ea89399f654c",

"ClientRequestUrl": "https://flow-apim-europe-001-westeurope-01.azure-apim.net/apim/dataflows/shared-dataflows-170acc99-7c57-4075-b410-b7d6-a4ca4fd3/api/groups/***/dataflows/***/refreshdataflow?workspaceType=Workspace"

}

{

"Pragma": "no-cache",

"Strict-Transport-Security": "max-age=31536000; includeSubDomains",

"X-Frame-Options": "deny",

"X-Content-Type-Options": "nosniff",

"RequestId": "6a571705-9579-485c-a090-a6093912b318",

"Access-Control-Expose-Headers": "RequestId",

"request-redirected": "true",

"home-cluster-uri": "https://wabi-north-europe-l-primary-redirect.analysis.windows.net/",

"Timing-Allow-Origin": "*",

"x-ms-apihub-cached-response": "false",

"x-ms-apihub-obo": "true",

"Cache-Control": "no-store, must-revalidate, no-cache",

"Date": "Thu, 17 Feb 2022 12:20:01 GMT",

"Content-Length": "518",

"Content-Type": "application/json"

}

I've hidden the IDs in the ClientRequestUrl for privacy reasons.

All responses (3)

Answers (0)

Community Power Pla... on 17 May 2022 at 07:49:06

Like (0)

Report

Re: Refresh dataflow fails with error code '400'

For us the problem was presumably caused by the dataflows being scheduled for refresh the same time as the power automate flow was running or the source data was being refreshed (this was during the testing phase of implementing the Power Automate flow.) After we made sure that during the run of the PA flow the dataflows and the source data are not updated/modified the problem ceased.
CU23071208-0 7 on 16 May 2022 at 14:06:32

Like (0)

Report

Re: Refresh dataflow fails with error code '400'

Same here. It works sometimes and fails other times and I don't know why it is failing.

{
    "statusCode": 400,
    "headers": {
        "Pragma": "no-cache",
        "Strict-Transport-Security": "max-age=31536000; includeSubDomains",
        "X-Frame-Options": "deny",
        "X-Content-Type-Options": "nosniff",
        "RequestId": "be02957a-ed7e-4eca-b6be-e558454fa9c9",
        "Access-Control-Expose-Headers": "RequestId",
        "request-redirected": "true",
        "home-cluster-uri": "https://wabi-us-north-central-c-primary-redirect.analysis.windows.net/",
        "Timing-Allow-Origin": "*",
        "x-ms-apihub-cached-response": "true",
        "x-ms-apihub-obo": "true",
        "Cache-Control": "no-store, must-revalidate, no-cache",
        "Date": "Mon, 16 May 2022 13:06:13 GMT",
        "Content-Length": "499",
        "Content-Type": "application/json"
    },
    "body": {
        "Message": "The backend request failed with error code '400'",
        "Reason": "Bad Request",
        "WorkspaceType": "Workspace",
        "OperationId": "RefreshDataflow",
        "ClientRequestId": "4fcb9e8f-0f89-45bd-aea4-2cbd5f17d39e",
        "ClientRequestUrl": "https://unitedstates-002.azure-apim.net/apim/dataflows/shared-dataflows-aa107e3d-da82-487f-989b-ecdcfa99b39e/api/groups/ad7a8766-848e-4f2b-8e85-ace0d69d6869/dataflows/7291f8fc-4163-4a29-b842-a7cbbe3a47e8/refreshdataflow?workspaceType=Workspace"
    }
}
Community Power Pla... on 11 Apr 2022 at 10:41:26

Like (1)

Report

Re: Refresh dataflow fails with error code '400'

Hi!

I have encountered the same problem, with the same errorcode:

  "Message": "The backend request failed with error code '400'",
  "Reason": "Bad Request",
  "WorkspaceType": "Workspace",
  "OperationId": "RefreshDataflow",

Did you manage to find a solution for this?

Thanks

Community site session details

Refresh dataflow fails with error code '400'

Helpful resources

News and Announcements

Quick Links

Announcing our 2025 Season 2 Super Users!

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

Refresh dataflow fails with error code '400'

Helpful resources

News and Announcements

Quick Links

Announcing our 2025 Season 2 Super Users!

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates