Topher60657 on 09 May 2018 21:51:12
Enable Incremental Refresh for Power BI Pro users, not just Premium.
Administrator on 20 Feb 2020 07:50:33
Happy to let you know, incremental refresh is now in Pro. Enjoy :)
- Comments (555)
RE: incremental refresh for Power BI Pro
Hi Anonymous,
could you explain a little bit more on how you've done this?
RE: incremental refresh for Power BI Pro
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.
RE: incremental refresh for Power BI Pro
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).
RE: incremental refresh for Power BI Pro
Yes really need this, as my data loads are way to large to pull the whole thing every refresh.
RE: incremental refresh for Power BI Pro
Is it possible to add incremental load functionality to Power Query? Pull and load just new or changed rows from source system