cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Update of historical data when using Incremental refresh

Hi everyone,

 

I have setup an incremental refresh on my Power BI dataset and I would like to know what are the best practices if one day I need to one of the following:

- Update historical data

- Add some logic on data source (SQL database). E.g. adding a new column on a view which is the main source of my dataset

 

Best,

Kevin

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Update of historical data when using Incremental refresh

HI  @Kevin_Conseil 

To my knowledge, you could refresh old data in incremental refresh in power bi for now.

here is a similar post for you refer to:

https://community.powerbi.com/t5/Service/Incremental-refresh-changes-in-old-data/td-p/971408

 

Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Solution Supplier
Solution Supplier

Re: Update of historical data when using Incremental refresh

Hi Kevin_Conseil,

I am not sure how you would "update" historical data.  If it is historical it isn't changing.  BUT, if you add a new column and pull in data that represents historical items, as far as the database is concerned, this is "new" data.  In my understanding, it should be pulled in because it is "new" to the data structure.  This would also apply to the addition of new columns. 

 

However, if you have the Incremental Refresh RangeStart and RangeEnd set so that it doesn't catch these changes then I would either change those ranges for one refresh to make sure I catch up on all of the data and/or turn off Incremental Refresh for one refresh.

 

Hopefully, you aren't changing historical data as a general rule though as that means your data is not as dependable as one might normally hope! 🙂 

Highlighted
Community Support
Community Support

Re: Update of historical data when using Incremental refresh

HI  @Kevin_Conseil 

To my knowledge, you could refresh old data in incremental refresh in power bi for now.

here is a similar post for you refer to:

https://community.powerbi.com/t5/Service/Incremental-refresh-changes-in-old-data/td-p/971408

 

Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors