Forum Discussion

DebbieE's avatar
DebbieE
Icon for Community Champion rankCommunity Champion
6 years ago
Solved

Incremental Processing with Excel and Sharepoint Lists as a Data Source

Ive been trying to help someone sort out incremental processing. When I asked about the data source, its a mix of Excel spreadsheets and Sharepoint Lists   I immediately thought that due to Query f...
Need Help
  • nickyvv's avatar
    nickyvv
    6 years ago

    DebbieE,

     

    According to the documentation, SharePoint lists is one of the Sources that support folding. However, Excel is not.

    This means that incremental refresh is not happening, because the engine needs to read the whole Excel sheet(s), and then perform the delta load. Depending on how you used the 2 sources together, it can be the case that also QF on the SharePoint list is not happening (for example if you combine the 2 sources).

nickyvv's avatar
nickyvv
Icon for Most Valuable Professional rankMost Valuable Professional
6 years ago

DebbieE,

 

According to the documentation, SharePoint lists is one of the Sources that support folding. However, Excel is not.

This means that incremental refresh is not happening, because the engine needs to read the whole Excel sheet(s), and then perform the delta load. Depending on how you used the 2 sources together, it can be the case that also QF on the SharePoint list is not happening (for example if you combine the 2 sources).