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

 

 

 

  • 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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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

    Hi  kb177 ,

    Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

    Best Regards