Forum Discussion

kb177's avatar
kb177
Helper II
3 years ago
Solved

Incremental refresh error message

Hello,   I'm getting the below error when setting up Incremental refresh   My data source is from share point file      
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi kb177 ,

    This is only waring message and not effect on the following configuration of incremental refresh. But before that, you need to check if the using data source support query folding. You can review this official documentation for the data sources that support query folding. And you can use the Power Query Diagnostics feature or trace queries by using a tool supported by the data source, like SQL Profiler to verify the necessary query folding is occurring...

    Incremental refresh and real-time data for datasets

    Best Regards

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi kb177 ,

This is only waring message and not effect on the following configuration of incremental refresh. But before that, you need to check if the using data source support query folding. You can review this official documentation for the data sources that support query folding. And you can use the Power Query Diagnostics feature or trace queries by using a tool supported by the data source, like SQL Profiler to verify the necessary query folding is occurring...

Incremental refresh and real-time data for datasets

Best Regards