How to setup Periodic Full refresh addition to regular Incremental Refresh.

[Anonymous]

How do you setup a periodic full refresh in addition to the more regular incremental refreshes? Maybe you do 6 incremental refreshes in a week, but once a week you want a full refresh?

I am interested in looking into the changes made in my archived data as well on periodic bases. Whats the best way to handle it? 

Thanks for all help in advance. 🙂 

[Anonymous]

Hi @Anonymous ,

I have found a helpful post, please refer to it to see if it helps you.

Solved: OData Incremental refresh compatible with schedule... - Microsoft Fabric Community

• Updated – Get SharePoint List Data … Fast – Hoosier BI
• Check out the second approach in this article that shows an example of using List.Generate to recursively use a nextlink type url to page through responses until the last one. The key step is the one called datalist.

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.