Faster SharePoint folder consolidation using Incremental Refresh (see warning in the notes)

⚡⚠️ Enabling incremental refresh means you will not be able to download the file from the service, so keep hold of that PBI desktop copy ⚠️⚡

Are you adding more and more files every day / week / month to your SharePoint or OneDrive folder and using Power BI to consolidate them? Is your refresh taking long and longer?

What if you could just add the latest file rather than re-importing ALL files every time....

This video shows how to speed up your refresh when pulling data from a SharePoint or OneDrive folder

00:00 Intro
02:54 Turning your filename into a datetime column
04:38 Adding RangeStart and RangeEnd parameters
06:15 Filtering the datetime column for the parameters
08:30 Setting up the incremental refresh time windows
11:15 Testing it out
13:32 The Result

Article by DataLineo
https://www.datalineo.com/post/power-...
and some extra info on partitions and dataflows
https://www.datalineo.com/post/powerb...


My previous videos explaining From Folder:

Basic:
   • The best way to connect to a SharePoi...  

Debugging tip
   • How to combine (and debug) Excel file...  

Using a File Path (and including sub folders)
   • Combine Files from SharePoint folder ...  



The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/

Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/


Connect with me
https://wyn.bio.link/