Keep information in PowerBI even if id deleted in the source (SQL Server)

[lvelasco71]

Hello

I have a source Data Base on SQL Server. Some historic data form the source is deleted on regular basis, only keeping the last 6 months.

Is possible to keep the data stored in Power BI even if is deleted from the source (and not be deleted in Power Bi when the data is actualized), because I need to keep all the historic data since the begining even if it was deleted form the source.

Example:

Time 1:          DB Origin          Power Bi Data

                       January              January

                       February            February

                       March                March

Time2:          DB Origin          Power Bi Data 

                      March              January

                      April                February

                      May                 March

                                              April

                                              May

Exists any manner to do that?

[amitchandak]

@lvelasco71 , check if DAX append methods 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/