i have some performance problems!

[Hikmet_JCI]

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?

[v-xulin-mstf · Accepted solution]

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]

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