Forum Discussion
Adding data each month
Hey GavinR87,
I would append the new query. (Here is how -> https://www.poweredsolutions.co/2019/04/09/combine-or-append-data-in-power-bi-power-query-main-concepts/)
But in order to still have your transformations in place I would
- Get the new Data
- Click on the "old query"
- Look at the transformation steps on the right hand side
- Click on that step where no transformation took place
- Do the append thing
- Now the append step is in between the others
- All the following transformations should work IF(!) the structure didn't change.
If this post was helpful may I ask you to mark it as solution and give it a 'thumbs up'? This will also help others
Have a nice day!
BR,
Josef
Graz - Austria
Hey GavinR87,
I would append the new query. (Here is how -> https://www.poweredsolutions.co/2019/04/09/combine-or-append-data-in-power-bi-power-query-main-concepts/)
But in order to still have your transformations in place I would
- Get the new Data
- Click on the "old query"
- Look at the transformation steps on the right hand side
- Click on that step where no transformation took place
- Do the append thing
- Now the append step is in between the others
- All the following transformations should work IF(!) the structure didn't change.
If this post was helpful may I ask you to mark it as solution and give it a 'thumbs up'? This will also help others
Have a nice day!
BR,
Josef
Graz - Austria
Hi Josef,
Perfect, thanks so much for the quick reply :)
I will give it a try tomorrow and let you know. Thanks again!
You are very welcome.
If something isn't working just reply to this message. I will try to answer it asap.