Dataflow is not refreshing ( Manual or automatic )

[BochIT]

Hello,

Year ago, I created simple dataflow contains data from DL2 ( Finance and operations export ) which stoped refreshing 3 days ago. There are no merges or calculations in it, just one custom column and data types changes.

Automatic refresh is ignored and the latest refresh time is not changing and stucked on. When I try manual refresh, the dataflow shows the refreshing cycle, but even after hours it is not done. After refreshing the page, the cycle is gone, but there DF is without change. There are no errors or any kind of issues.



We are not using premium capacity or Fabric. Refreshing worked great until the 25th and this day there were no changes which can damage this.



This DF is core for many our reports so I cannot just remove it and create a new one.

What I tried
1.) All kind of refreshes from workspace or query editor
2.) Turn on and of the automatic refresh, change the time
3.) Create new step or remove last step from DF query
4.) Moving the DF from one to another folders in workspace
5.) Run the refresh from Power automate ( It just ends with error 400 )

Do you please have any advice ?

[BochIT · Accepted solution]

Issue was resolved after 5 days without our changes.

Do not know what or where the issue was.

[v-yajiewan-msft]

Hi @BochIT ,

I would like to confirm whether you need to re-authenticate your data source credentials?

If you are using local source, please remember to upgrade to the latest version of the on-premises data gateway.

In addition, you could also post a detailed message about Error 400 when refreshing from Power Automate.

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[BochIT]

Hello,

There wasn´t any issue with authentication, I am not using local source in this DF.

Issue was resolved without our changes, after 5 days.

I am posting the Power automate error, but is is just empty 400 message.

{
  "Cache-Control": "no-store, must-revalidate, no-cache",
  "Pragma": "no-cache",
  "Strict-Transport-Security": "max-age=31536000; includeSubDomains",
  "X-Frame-Options": "DENY",
  "X-Content-Type-Options": "nosniff",
  "RequestId": "", // Removed by me
  "Access-Control-Expose-Headers": "RequestId",
  "request-redirected": "true",
  "home-cluster-uri": "https://wabi-west-europe-d-primary-redirect.analysis.windows.net/",
  "Timing-Allow-Origin": "*",
  "x-ms-apihub-cached-response": "false",
  "x-ms-apihub-obo": "false",
  "Date": "Fri, 27 Sep 2024 06:17:58 GMT",
  "Content-Length": "", // Removed by me
  "Content-Type": "application/json"
}

{
  "Message": "The backend request failed with error code '400'",
  "Reason": "Bad Request",
  "WorkspaceType": "Workspace",
  "OperationId": "RefreshDataflow",
  "ClientRequestId": "", // Removed by me
  "ClientRequestUrl": "" // Removed by me
}

Thank you.