incremental refresh for Power BI Pro

[Topher606571]

Enable Incremental Refresh for Power BI Pro users, not just Premium.

[rford1]

When is this going to be done?

[dave_mcnab]

Good news and this is a good start, but incremental refresh on time cycle is not exactly what we had in mind.... we want to append new data to existing data from sources like CSV. The use case is adding a period's data to an existing model. In other words instead of truncate (delete) and replace data we simply want to tack it onto the table that's already there. Otherwise accumulation of time series data has to be done outside the tool. Of course you don't want to accumulate forever, so being able to selectively delete date ranges of data within specific tables would be a natural companion functional requirement. The only other choice at present is to use another database to accumulate time series data. This is fine but adds complexity for users. Access can only scale to 2GB so it's no good for this, which puts you into the realm of "real" databases, which are too complex for a lot of smaller enterprises. Anyone doing periodic time series updates would benefit from this easy to implement feature... and that means almost any small to medium size business, which i believe is important to success.

[Michael_Hughes]

Hi, coulf you make it possible to keep data for a rolling 24 hours and load new data every two hours (as the relevent old data is removed from the service)? One of our API's makes a call to one of our internal systems on a ~2 hour basis, extracting the most relevant information for say 10% of our requests (eg the next 200 combinations of city pairs out of a total ranked 2,000) and places the results in a Oracle database (200 city pairs equals output of around 12m records). Our Oracle database is emptied everyday at midnight meaning that we dont get the vast majority of the 'city pairs' until later in the day when everyone has gone home (because the API starts at city pair '1' and goes down the list). I want to keep the data for say 22 hours, and load the new data as it comes in using Inremental loading, whilst dropping off the previous days 1-200 city pairs when todays pull of 1-200 city pairs is added.

[d_valeiras]

Is there a scheduled date for PRO users? When will we have other users?

[oz1_depot]

Great announcement BUT that email domain issue prevents me from even being able to show a client what's possible.

[matthew_jin]

this feature will allow appending new data to existing as far as I can tell. For example, you can set "store rows in the last" to 10 years, and "refresh rows in the last" to 1 day will continue to add last one day of data to existing dataset which will keep appending data for the next 10 years as long as the storage limit is ok. Did I not understand this feature correctly?

[DQ]

Please expedite for Pro. Most user's I am sure are Pro. I am running multiple SSIS packages to update my SQL server table prior to refresh. Big time saver.

[pbiideas1]

Cool. Any timeline for Pro users?

[jorge_cortes]

Any News on this? It has been opened since 2015 . . .

[stuart_honeyman]

When can we expect this for Pro users? TBH I think this is poor form to only allow the feature for Premium users only