Load table append data

[fkeuroglian]

Hi Experts!

I would like to know it there is any way to do this case:

For example, i have one table, called GENERAL, that if i do a select today will give me the information about june 2021, but if i create the select in August, the table only store the data of August.

Conclusion: the table only have info of the current month, and the next month, DELETE and insert the info of the actual month.

Is there any way to create a process in PBI, that help me when i do the SELECT * FROM  GENERAL, that persist and append to my HISTORICAL GENERAL TABLE? do an APPEND AUTOMATIC IN PBI,

My table only have the current month, POWER BI will have all my Historical data.

Thanks Fernando

[Greg_Deckler · Accepted solution]

@fkeuroglian Historically there's generally been no clean way to do this in Power BI. However, you might be able to get what you want using Incremental refresh.