Views:

Applies to Product - Power Apps


What’s happening?
Customers are experiencing dataflows getting stuck in progress or failing to refresh.


Reason:

  • Dataflows may become stuck in progress due to issues with data source connectivity or configuration.
  • Errors related to dataflows may occur if there are problems with the data source credentials or configuration.

 

Resolution:
  1. For Dataflow Stuck in Progress:
    1. To cancel a stuck dataflow, click on the three dots (ellipsis) next to the dataflow name and select the "Cancel refresh" option from the dropdown menu.
    2. If the UI option does not work, use the Power BI API to delete the dataflow.
    3. If using an on-premise data gateway, restarting the gateway service may help in stopping the stuck dataflow.
    4. Disconnect from the data source to see if it stops the refresh process.
  2. For Dataflow Refresh Failing:
    1. Ensure that all connections (data sources, endpoints, etc.) required by the dataflow are correct and active.
    2. Validate that any recent configuration changes (e.g., credentials, connection strings) have not inadvertently caused issues.
    3. Review the refresh history and download the refresh history file for failure reasons.
    4. Ensure that the necessary permissions are in place for the user attempting to refresh the dataflow.
  3. General Troubleshooting Steps:
    1. Check for error details in logs or notifications related to the refresh process.
    2. Confirm that the underlying data sources are reachable and performing as expected.
    3. If this persists, consider creating a new dataflow from scratch with the proper configuration.