Incremental Refresh with SharePoint Files 

Thank you for this! I've read how to do incremental refresh for SharePoint files in blog posts but you're the first one to do a step-by-step walkthrough. I was able to enable the incremental refresh feature for all 15 fact tables (all in SharePoint) in my data model. Refreshing used to take hours due to the size and history of the fact tables but now it doesn't take 10 minutes!

You my friend, deserve a like.

This is genius. Thanks, man,

Thanks a lot for this video, I just implemented a similar solution and was wondering that incremental refresh would work or not, since Sharepoint is a non-foldable source.

Awesome! Any guidance on how to apply this with Dataflow and the way incremental refresh works there ? Thanks in advance!!

Much appreciated👏👏

Thank you!

Is there a way to avoid duplicates due to the update of a record that is part also of the historical data?. I keep getting this error when running the refresh in the workspace. Column 'GRP Number' in Table 'Fact>' contains a duplicate value '46131' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table. Thanks

fucking bi master!! Thank you for this

Do you have any suggestion to a semantic model that takes forever to process after conncting to a sharepoint file? File has a little over 5000 rows with 16 columns.

Sugestão... Poderia utilizar a própria coluna Date modified para usar os parâmetros RangeStart e RangeEnd parâmetro...

So I followed the steps you showed, but my incremental refresh will nor respect the 2 years of archival data that I setup. I will only pull the last 30 days (the refresh setting), multiple refreshes done already. What could be the issue? I know incremental is on because Power Bi cloud will not allow me to download the file.

I did get the process but how to combined data (old and new) while perform latest dashboard.

I tried it but it keeps on throwing errors for column not found and the error is not giving information on which table it’s referring to…I checked all my tables and all the steps are the same and it works on my file without incremental refresh set-up…

What if we want to remove one file after it's loaded? and how we can do a full new load again if required for some reason?