Incremental Refresh SharePoint folder files

[hasharma19]

Hello Everyone,

I have 2 yeare data stopred in excel files in sharepoint folder and i want to implement incremental refresh, since full refresh is taking almost 10 hrs( due to 70k row with 150 columns data added every week in single excel files).

I tried to perform steps which i saw in many post but not able to get through.

Tried with this post, firstly not sure if am using correct custom funcation, as while using that nothing is showing, the message poping up that table is empty. Please help me with writting customs funcation and how to implement that

https://www.thepoweruser.com/2020/01/19/incremental-refresh-for-files-in-a-folder-or-sharepoint-powe... 

[ppm1]

Please see this video that walks through how to do this with SharePoint files.

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

Pat