incremental refresh for Power BI Pro

Happy to let you know, incremental refresh is now in Pro. Enjoy :)

Is it possible to add incremental load functionality to Power Query? Pull and load just new or changed rows from source system

Yes really need this, as my data loads are way to large to pull the whole thing every refresh.

Yes it is. But you have to use advanced editor. The way I did this was to first load data from an input file into a table. Then I created a second query that loads data from that newly created table. Then I used advanced editor to change the first query in start with the steps from the first query and append the results. And you can avoid duplicate rows by creating a new column with some sort of compound key from your various columns (and later remove this column if you want, once dups are removed).

I suggest to transform the checkbox "Enable refresh of this query" to a radio button with "Enable refresh..."+*"Disable Refresh..."* options, untied from the option "Enable load to report". If you check the "Disable" option you could refresh the query only manually and thus you can perform an incremental data load staging data in one or more disabled queries and combining them with which are enabled.

Hi Anonymous, could you explain a little bit more on how you've done this?

Basically here is the use case. We have to load a fact table with say 1 million rows and daily 50K rows get added. I would want to the refresh operation to just add those new 50K rows or maybe only those with some update stamp.

This post http://ms-olap.blogspot.com/2015/05/incremental-data-loads-in-microsoft.html says it works in Power Query for Excel. I tried doing the use same in Power BI Desktop but it still refreshes the existing data even thought refresh has been disable for that query.

what we really need is the ability to incrementally load data into a power pivot data model

I'd also like there to be straight forward way of doing this please!