Configuring Incremental Refresh in Power BI

In this video you learn how incremental refresh works in Power BI. You can use it to reduce refresh times, improve reliability and reduce resource consumption.

Master Functions and Syntax in M

ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.

SUBSCRIBE TO MY CHANNEL

LET'S CONNECT:

Thank you for your support!

Chapters:
00:00 Introduction
00:20 What is Incremental Refresh
01:15 Prepare Power Query
05:52 Configure Incremental Refresh
10:38 Power BI Service
12:13 Considerations

#IncrementalRefresh #PowerBI #BIGorilla

[vheveljo]

Yes thx!! Very helpful... Just one remark: To enable this feature, first have to go to the View tab in the Power Query editor and select the Always allow option in the Parameters group.

[cloudpathshala]

Great video, straight to the point explanation of the concepts and practical implementation.

[mischapeters]

Very very helpful Rick. Could you also create a tutorial may'be where you go into the setup of the dataflow/ dataset / incremental refresh. Kinda curious how you link this all together!

[hananemallek]

i have been follwing power bi courses on udemy, they hardley explain incrimental refresh, yours is much better i was able to understand completely from the first attempt, thank you very much for this channel

[damn]

You're the best, thanks for confirming the naming Rangestart for it to work.

[osPA]

This was a great and informative video. One thing that I did forget was about not being able to download the PBIX once incremental refresh has been applied. THANK YOU!!!!

[akshai]

Well explained!! I was able to follow each step very clearly. Thanks for making this video, it was very much useful

[lathakottapalli]

Hi, I really appreciate how simply you were able to describe things. What can I do now that my "View native query" option is greyed out and my source is an Oracle database? My requirement is basically that my data changes every day, replacing old rows with new ones. I want to save the old data as well as the new, and I want the new data to be appended to the old.

[krishnakoirala]

Very helpful and explained in very understandable way, thanks!

[alt-enter]

Nicely done! and I have your newest book open beside me right now!

[fajnefajne]

Hi Rick, this is a wonderful tutorial. Thank you very much. This topic is not very popular on YT so any further videos on this topic would be very welcome. Thank you.

[pupycron]

This was such a great, clear, and well explained video! Excellent work :)

[thristonsookram]

Very well explained. Been having issues implementing incremental refresh but this pretty much clarifies everything. Thanks !

[romualdulcyfer]

Really great video makes this subject quite simple to seem. I'll try to follow you step by step. If u could comment on "data modification" would appreciate much

[PedroCabraldaCamara]

Very good video Rick. Thank you so much!

[filipef.]

Very helpful video, however I need to add something ( maybe it is because, two years ago native query was disabled in PQ in general ? )
You mentioned about "View native query" option that can not be greyed out, which is not 100% true. It can be greyed out and still incremental refresh works. For example for Databricks data source. Even though "View native query" is disabled, using -> Databricks.Query() function to create a SQL statement with RangeStart and RangeEnd parameters makes incremental refresh works. All the steps in terms of configuration after PQ, has not changed.

[newbobotime]

Hi Rick, and thanks for this video tutorial
I followed the steps but I still see "View Native Query" disabled I'm trying to set incremental refresh on Teradata table.
Do you have any idea why it is disabled?
Thanks in advance

[rreneijhorst]

Hi Rick, great, interesting topic but most of all very well explained!

[decentmendreams]

Thank you so much. I am in the process of redesigning my reports and IR is an integral part of this. This week, I learned that you don't have to have query folding capability in order to implement IR which I thought was the case. You can apply IR to a file folder sourc If you have a set of files with period changes. The other thing is, navigating the limitations you mentioned in your video. Your suggestion of separating Reports and Models is one way to circumvent this which I like. I also have been flirting with DataFlows and you mentioning it makes me consider it as well. One thing missing in your demo is how Direct Query Mode affects this. May be an idea for a followup video?
IR seems a very important issue and am wondering why Microsoft doesn't allow it at the Desktop Level.What is your take?Economics or design challenges ?
Thank you for all your hard work in teaching us PBI.PQ.

[yevgeniypopov]

Great video. Thank you!
I have 100 Mln+ rows and 30 columns and dataflow works with problems...
Can't use dataflow(