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.

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!

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

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

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

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.

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!!!!

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

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.

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.

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

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

Thanks for the video, in the last case, when you connect to a dataflow that incrementally refreshes, wouldn't the dataset load entirely the data again and again? because the incremental is in the dataflow and not in the dataset?

good advice Quetios if they want a Incremental refresh but the information refresh every Hrs can do it??

Very helpful and explained in very understandable way, thanks!

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.

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

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

Thank you! Very well explained! What if I add a new column do this table? Will it make a full refresh and later automatically incremental refresh? It's because my table is too heavy but we usually have to add some column to it.

I have a question about this. So let's say that the main table that feeds the visuals, is a table that is comprised of an appended table. How would I go about creating the incremental refresh to it? Should I do it with the table of the append, that is changing? Should I apply it to the appended one? Cheers!

Hi Rick, first of all i dont realy understand why I need to filter the data in tables using the parameters. Why is this a requirement? and what if I have multiple fact tables in my model and I would like to have different Start / End Range filters on the different tables. is it posible to make such parameters per individual date tables? if so how, if you can only RangeStart and RangeEnd as the parameter names. Cheers, joris

Thanks for these wonderful tutorials, I just have a question please, do I need to make sure the dates in my Rangestart and Rangeend meet the max and min date values in my dataset or I can just use any default dates while creating the parameters.

are you sure it will be faster than the full refresh? Because mine in semantic model and dataflow are the same, they are take longer than then full refresh

Very clear tutorial thanks! In my case I have a plain date column in my dataset. The documentation only seem to cover the cases of a datetime column or a date column of "integer surrogate keys in the form of yyyymmdd". Transforming the date column to datetime inside powerBI leads to query not folding. What would be the advisable course of acrion here? Turn my date column into datetime in my db? Create an extra column with integer surrogate keys? Thanks in advance

This very helpful. Can you do an incremental refresh on a reference table?

When I filter it is not showing me native query but it show in above step. I am getting my data from API from Zappysys through ODBC connection can it be possible to get increment refresh

Really helpful, thank you

Incredibly helpful video. Thanks

Very useful, thank you!!

Hello, beautiful explanation, I had one doubt on the incremental refresh. I am not ableto greyed out and not able to make it active. please help on the same

Very good video Rick. Thank you so much!

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

Is this technique in any way different from this one: 1. Create Table1 that loads data till say 1/1/2024 and set it to not "Include in Report Refresh" and not "Enable Load". 2. Create Table 2 that loads data from 1/1/2024 till today. 3. Append Table2 with Table1

Very informative video Rick My question here is does this incremental refresh work if the data source is a stored procedure?

very helpful. thank you

What's Crazy is Licensing Types, This is a Premium level feature and only works if the end user has premium license too.

Hi thanks for the explanation. I was wondering if my SQL table changes (new column, deleted column, renamed column) and I need those changes to be reflected in the Dataset, how does the incremental refresh handles that or it doesn't and we have to create a totally new power bi file, republish and perform a full refresh ?

HI Rick, I followed each an every step described in the video. I am still unable to get the incremental refresh setup for the data source.

I need an Arabic ocr engine , can you recommend one to use

Well explained, thanks for this.

Doest it need native query? I got datasets without native queries....I am loading data from dataflows.

How to set up this Azure Analysis services ? We are using Visual studio to develope the model and then deploying in Azure analysis service . Everyday we are doing a full refresh and source datasize is more 500 GB from Oracle . We are not using PBI destop to author data model .

How to do incremental refresh for scd type 2 tables in power bi

Hi Rick, how will I set up if I would like to Achieve data 3 years before refresh (1/1/2019 - 3/31/2022) but Incremental refresh from 2 months before refresh until future data (4/1/2022 - 5/31/2025). Because I have some data for the future that needs to be refreshed too?

Does incremental refresh worked on merged and appended tables?

Hey! View Native query is disabled for me after filtering :(

Really helpful

I have an oracle database and getting the table from a datamart as the data is big in size but when I imported the table by using a SQL query, I can't see the (View Native Query) option it's greyed out.. Help?

Great video, thanks for explaining the pre-requisite, mostly of our queries are web api so not really supported :-(

Thanks for the simplicity! This only applies for Import mode right?

Great!

I have a fact table with start_year (2020) and end_year(2023) parameters in it to limit the number of years worth of data. On top of this I have incremental refresh of last 13 months. I publish this file to web service and change the start_year parameter say from 2020 to 2019. Why does the parameter changes in web service doesn't take into effect? If I change from 2020 to 2021, it does make necessary changes but for the first time only after publishing the file. Any thought on this? My report should only hold only last 5 years of data with last 13 months of incremental refresh.

Hey Rick, How are you doing? I am contacting you as I am interested in learning some power bi advance level.

Can you explain the need of parameters

Thats the reason why you do not use any office products. You have to pay for things you are able to programm yourself.

Those mouse click sound is just super annoying 😒 otherwise thanks for the tutorial on incremental refresh..

Why does nobody address whether this wroks with pulling the data from a dataflow? omfggggggggggggggggggggggG