Forum Discussion

Hikmet_JCI's avatar
Hikmet_JCI
Helper I
4 years ago
Solved

i have some performance problems!

Hello, everyone i have some performance problems!   my data model is   these data are on the Sharpoint folder   file A 800MB data from 2010-2015 file B 800MB data from 2016 - 2020 file C 200...
Need Help
  • v-xulin-mstf's avatar
    v-xulin-mstf
    4 years ago

    Hi Hikmet_JCI

     

    Duplicate the Sharpoint folder table:

     

    Set as:

    Apply a filter in the duplicate table:

    Set as:

     

    If you still have some question, please don't hesitate to let me known.‌‌

     

    Best Regards,

    Link

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

lbendlin's avatar
lbendlin
Super User
4 years ago

Use incremental refresh based on the Last Modified Date of the files.  Ignore the Query Folding warnings.