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!
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.
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
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.
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…
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.
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!
Glad to hear it helped
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.
Much appreciated👏👏
Thank you!
Awesome! Any guidance on how to apply this with Dataflow and the way incremental refresh works there ? Thanks in advance!!
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
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.
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…
fucking bi master!! Thank you for this
Sugestão... Poderia utilizar a própria coluna Date modified para usar os parâmetros RangeStart e RangeEnd parâmetro...
I did get the process but how to combined data (old and new) while perform latest dashboard.
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.
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?
If on premium, you can use XMLA to do a full refresh. Otherwise, you can republish your report/dataset.