Would incremental refresh in lakehouse allow me to add only today's data?

[mds123]

I'm currently looking at getting premium for the lakehouse and its warehouse capabilities. My main data sources include SQL Server and daily Excel files related to factory production and spend that are uploaded to SharePoint. A problem I have is users making changes to data in our data sources a few days or weeks after the data is made.

I want to be able to save that data into a lakehouse table and then, every night, automatically refresh the table to only add the new data. The new data would be based on the most recent file or a date field in SQL Server. Does Lakehouse support this behavior with an incremental refresh? If so, this would be huge and allow me to stop fearing losing old Excel files. I'm not very familiar with it and am a little confused. 

[kishanthacker]

As per the description I think you are referring to incrementally load the data. The same is neatly explained in below blog.

https://learn.microsoft.com/en-us/fabric/data-factory/tutorial-setup-incremental-refresh-with-datafl...

If it helps you than kindly mark this as solution. Thanks.

[Anonymous]

제 생각에는 MS Fabric의 기능 중 하나인
Dataflow Gen2를 이용한다면 가능할 것 같아요!

Dataflow Gen2는 Power Query 기반이기 때문에
관련 공식 기술 문서를 첨부드립니다.

https://learn.microsoft.com/ko-kr/fabric/data-factory/tutorial-setup-incremental-refresh-with-datafl...
https://learn.microsoft.com/ko-kr/power-bi/connect-data/incremental-refresh-overview