Import data from google spreadsheet and add it to last dataset, upon refresh

[holodan95]

Hello All,

I would like to ask you how can I add fresh data to an existing dataset in power bi?

I have a google spreadsheet table with the following data on the first import:

Item1	50
Item2	60
Item3	40
Item4	30

When I make another refresh, the google spreadsheet table have these data:

Item2	70
Item6	55

The result should be this:

Item1	50
Item2	60
Item3	40
Item4	30
Item2	70
Item6	55

Is it possible somehow?

Thank you!

[amitchandak]

@holodan95 , check if DAX append methid can help

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-...
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/