⚡⚠️ 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
www.datalineo.com/post/power-...
and some extra info on partitions and dataflows
www.datalineo.com/post/powerb...
My previous videos explaining From Folder:
Basic:
• The best way to connec...
Debugging tip
• How to combine (and de...
Using a File Path (and including sub folders)
• Easily enter a File Pa...
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. accessanalytic.com.au/
Did you know I've written a book "Power BI for the Excel Analyst"?
pbi.guide/book/
Connect with me
wyn.bio.link/
14 июл 2024