Forum Discussion
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 200MB data from 2021
all files have the same columns, A and B are not updated, only C
With a Sharpoint folder connection I get a file, but I cannot switch off A and B for the update
how can i improve this?
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!
2 Replies
Use incremental refresh based on the Last Modified Date of the files. Ignore the Query Folding warnings.
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!
