Skip to main content

    Power BI

    Completed

    incremental refresh for Power BI Pro

    Vote (13097) Share
    Topher60657's profile image

    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 (643)
    Topher60657's profile image Profile Picture

    a020250b afab-450a-ac4c-a581aa5b3418 on 05 Jul 2020 22:13:53

    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).

    Topher60657's profile image Profile Picture

    ef397e6c 0e42-4c54-a363-81920582fab0 on 05 Jul 2020 22:08:31

    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.

    Topher60657's profile image Profile Picture

    d924d455 423d-4de6-aee9-5827f18d8d67 on 05 Jul 2020 21:59:09

    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

    Merged Idea (1)