title | description | author | ms.author | ms.reviewer | ms.date | ms.custom |
---|---|---|---|---|---|---|
Data refresh fails and dataflow refresh is skipped |
Solves an issue with the data refresh schedule for Power Query-based data sources in Dynamics 365 Customer Insights - Data. |
m-hartmann |
mhart |
mhart |
01/03/2024 |
sap:Data Ingestion\Connect to a Power Query data source |
[!INCLUDE consolidated-sku]
This article provides a resolution for an issue where the Power Query data source isn't refreshed successfully in Microsoft Dynamics 365 Customer Insights - Data.
The Power Query data source processing status is Completed with errors, and you receive the following error message:
System triggered refresh succeeded; however, dataflow refresh was skipped because the System refresh settings are not applicable for this datasource. If you want this datasource to be refreshed periodically, please configure the scheduled refresh through "Edit refresh settings" options.
Dynamics 365 Customer Insights - Data has two refresh options: system refresh and data source refresh. Power Query-based refresh is set by the owner of each data source. System refresh is set by the administrator and controls the rest of the data sources and downstream processes.
The error message means that the system refresh in Customer Insights doesn't refresh Power Query data source, but only copies the previous state of the data source.
To solve this issue, configure the refresh schedule for the Power Query data source by editing the data source settings.