Power Query data source refresh issues for data sources based on Power Platform dataflows

Note

On September 1, 2023, we merged and renamed Dynamics 365 Marketing and Dynamics 365 Customer Insights. Dynamics 365 Marketing is now called Dynamics 365 Customer Insights - Journeys. Dynamics 365 Customer Insights is now called Dynamics 365 Customer Insights - Data. For more information, see Dynamics 365 Customer Insights FAQs.

This article can resolve issues if data is stale or you see errors after a data source refresh for Power Query data sources that are based on Power Platform dataflows.

Prerequisites

You need permission to see and update dataflows.

Symptoms

You may find the following issues:

• Ownership of the data source has changed. If the status of the dataflow is "Success," the ownership of the Power Query-based data source might have changed.
• The data refresh status of the dataflow is "Failed."

Resolution

To solve the issue, take the following steps:

1. Sign in to Power Apps.

2. Choose the environment with your Dynamics 365 Customer Insights data and navigate to Dataflows.

3. If the status is "Success":

   1. Review the refresh schedule from the refresh history.
   2. Set the new owner's schedule and save the settings.

4. If the status is "Failed":

   1. Download the refresh history file.
   2. Review the downloaded file for the reason for the failure.
   3. If the error can't be resolved, open a support ticket. Include the downloaded refresh history file.