Two Tables - How to Subtract data

Hi @Ciria,

Since it seems that you are loading data into a data model to do reporting on, I would suggest that a straight “truncate and load” paradigm would be best. That means just replace all your data with every load. Then you will always have a correct snapshot of your data.

If, however, you happen to have a relational data warehouse with an actual ETL process, you might be able to use an incremental load into the DW that just picks up the records that changed. This requires some complex pieces through, including at least record edit dates in the source system and an ETL process that tracks the last time it ran so the next time it only grabs records changed after that time.

Even in the above case, you would still use a “truncate and load” in your data model for your Power BI report because the DW has the updated data.

So, if this info isn’t helpful, we would need to know more about what you are trying to do in your data model/report and more about any issues exporting the full updated source data from SAP.

John C. Pratt
Enterprise%20DNA%20Expert%20-%20Small