How can we improve Power BI?

Incremental Data Loads

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

3,680 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

Javier Recasens shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

We’re pleased to announce that in the May release of Power BI Desktop you can now define incremental refresh policies for your models.

At present these only apply once the model is published to a Premium workspace in the Power BI service; we’ll be bringing it to all Pro users in the future.

You can read more about it in our blog here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2018-feature-summary/#incrementalRefresh

We’re going to leave this idea open for now, so please give us your feedback while we’re in this preview phase!

407 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
  • TA commented  ·   ·  Flag as inappropriate

    This is July 2nd 2019, and we are still waiting for incremental data load on Pro.

  • pichai commented  ·   ·  Flag as inappropriate

    Google BigQuery is not supported yet. please add incremental refresh support to BigQuery. BigQuery is SQL-compliant so I'm not sure why query folding doesn't work.

  • jot commented  ·   ·  Flag as inappropriate

    When do you expect to release this feature (preview or GA) for PRO licenses?

  • Vasek commented  ·   ·  Flag as inappropriate

    Will, a year ago you wrote "... we’ll be bringing it to all Pro users in the future".
    Will be "future" next month/quarter/year or when?
    Looking forward so much for this !
    Thank you for answer

  • Anonymous commented  ·   ·  Flag as inappropriate

    Going to add my voice to say add it to Pro accounts.

    Would love some sort of update/reasoning behind keeping it locked to Premium accounts for over a year now. Clearly the feature works, so what's the hold up?

  • Gian Pier Barchi commented  ·   ·  Flag as inappropriate

    We need this urgently. Clients are beginning to complain about refresh failures because of large datasets or refreshes taking too long to complete. How hard can it be to make this feature available to Pro Users?

    Since May 2018 this feature has been available to Premium users, it’s going to be a year and Pro users are still missing this.

  • Anonymous commented  ·   ·  Flag as inappropriate

    I got approval for 40 pro accounts to pilot the viabily of this awesome tool, the work-arounds are real, please make this a standard feature

  • Vicente Moreno commented  ·   ·  Flag as inappropriate

    We still do not find the incremental load in August 18 desktop.
    We have Pro licences but we need to use the desktop since there is no connection to our DWH from app.powerbi.com

    What can we do ?

  • Anonymous commented  ·   ·  Flag as inappropriate

    We load travel - hotel and air expenses every month. It would be nice to add load these files incrementally

← Previous 1 3 4 5 20 21

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.