Incremental refresh and Access

[marcin_pirx]

Hi,

I am trying to set up incremental refresh with Access database as the source. Is it even possible? I couldn't find any specific information on this topic.

[marcin_pirx]

I can't set up incremental refresh with Access as the source. "View Native Query" option is grayed out, and I aded just one step (filter date column):

[Uzi2019 · Accepted solution]

Hi @marcin_pirx 

You can't apply incremental refresh if native query is greyed out. that's the restriction.

I hope I answere your question!

[Uzi2019]

Hi @marcin_pirx 

You can create incremental refresh on simple excel data source also. just follow the proper steps to implement it.

https://www.youtube.com/watch?v=fZVtlckIYvY

https://www.youtube.com/watch?v=Kui_1G6kQIQ

Refer above videos for better understanding!