OpenTube

Incremental Refresh in Power BI

PorcuBI - Valerie Junk

42,392 views

Speed up your Power BI refresh times with Incremental Refresh! In this video, I’ll show you how to set it up and explain why it's essential for large datasets. Learn how to define parameters, configure the refresh policy, and avoid common pitfalls.

Microsoft Learn documentation: https://learn.microsoft.com/en-us/pow...

Subscribe to stay updated on my new content!
---------------------------------
⏰ TIMESTAMPS
---------------------------------
00:00 What is incremental refresh in Power BI
01:10 Requirements for Incremental Refresh
01:48 Power BI Configuration
02:13 Parameters RangeStart & RangeEnd
03:43 Filter the date/time column
04:37 Configure Incremental Refresh
05:41 Additional Settings
07:56 Power BI Report
08:40 Limitations
10:11 Summary

---------------------------------
😊JOIN
----------------------------------
Website https://www.porcu.bi
LinkedIn LinkedIn: valeriejunk
Bluesky https://valeriejunk.bsky.social/

#powerbi #PowerBITutorial #powerbidesktop #PowerBITraining #powerbitips #Reports #powerbideveloper #PowerBIReports #BusinessIntelligence #Fabric

20 Comments

@bamokinamoandadestin7888 2 months ago

Great job, you just saved my day! I have a huge volume of data going back to many years of production data. And guess what? Each time that I refresh them it takes an eternity.

@ehsanjafari1035 3 months ago

The explanation was perfect and clear. Thank you.

@alicedwonderland7733 7 months ago

clear and beautiful, Valerie! Thank you!

@Kranthi_Kumar_A 7 months ago

Clear Explanation, thank you

@aslansharif 3 days ago

👌👏

@das_babuu 1 year ago

Simple yet great explanation💯

@jorgemendoza1160 1 year ago

super clear, thank you!

@meetshah5287 1 year ago

Perfect video for Interview prep

@Soulenergy31 10 months ago (edited)

1:44 date time format
4:40 need to do its second part

@richgouette 1 year ago (edited)

Great video Valerie!

@manuelboadi1343 2 months ago

Thanks for the explanation. I’ve tried it, however after the date range I specified in the power query, the values I’m getting in my visuals are quite different from the values I get in my manual refresh

@ewanstevenson4721 7 months ago

Thanks Valerie. Its a very useful overview. We tried the download of our pbix and if I remember correctly if you set it to be Large Semantic Model storage format it allows the download. No idea why but I know for sure we got that to work. I cant check this for you as I no longer have access. Also, I'm sure you know this already but Tabular Editor will allow you to make changes to your model without it needing a full refresh like in a pbix Publish but of course that's not free. Maybe things have changed, many Tabular Editor capabilities seem to now be available in Power BI itself. Well overdue! :)

@SaswatiPadhee 8 months ago

Using Google bigquery connector, did the same process of parameter creation (Type:date) and applied to a 'date' column. However, in the model view -- right click on the table, incremental refresh still says needs to setup parameter. what can be the issue here?

@abe_datastrangler 1 year ago

What was your data source for incremental refresh, SharePoint?

@chandra-chandra 10 months ago

As I have pro licence and using f64 workspace can I do incremental refresh once parameters are applied.

@vineetdua1206 8 months ago

Can we successfully configure Incremental Refresh with query folding against Google BigQuery in Power BI? I’m running into an issue where native query (folding) isn’t being enabled even when my Power Query steps are minimal - i.e., I connect directly to the source and only apply RangeStart/RangeEnd filters on a single, partitionable datetime column.

@Sebastian_ti 10 months ago

Hello. How did you do the "incremental Refresh" table? To add a new row when refresh?

@davidhogeling978 9 months ago

Note that the parameter selection for filtering only appears when the date/time/zone type of the parameter is a 1:1 match with the selected column.

@gl-liz3434 11 months ago

Perfect Demonstration of Incremental Refresh. However, I was wondering how we will update the Parameter days? which is hard-coded.

@jackstrudley1039 5 months ago

Hi Valerie,

I've always used incremental refresh without issue in Power BI against SQL views in our Data Warehouse, I'm now trying to repeat this for Fabric Warehouse views and despite everything appearing to work in terms of setup the service ignores incremental refresh and just refreshes the entire Dataset each time.