How to implement incremental refresh in power bi with excel as data source ?

[Pankhuri_16]

I have a data source project online with no date column. I am unable to add a custom date column in project online . Apart I tried exporting this data to excel but unable to implement incremental refresh with excel as datra source in power bi. 
Any leads on this ?

[amitchandak]

@Pankhuri_16 , You have scheduled a refresh, it will load data again. As data can fold, it will always load full data filter at the target

https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh

For on-premise Excel, you need an on-premise gateway

Power BI Install On-Premise Gateway and configure it on service: https://youtu.be/lObMRofpbQ8

[amitchandak · Accepted solution]

@Pankhuri_16 , You have scheduled a refresh, it will load data again. As data can fold, it will always load full data filter at the target

https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh

For on-premise Excel, you need an on-premise gateway

Power BI Install On-Premise Gateway and configure it on service: https://youtu.be/lObMRofpbQ8