Loading Updated Data only

[harshaSampath81]

Hi,

I used Import method and refresh data scheduly , here when data load all data loaded to BI service? Do we have any method to load updated data only(without loading all data every time) is there any method to identify updated data ?

Thank you

Harsha

[v-shex-msft · Accepted solution]

HI @harshaSampath81,

If your data tables contains some data column which similar as 'Create date, Update date', you can add t-sql query to advanced option to let power bi only load the changed data.

I haven't found other methods to deal with this scenario before get data into power bi.

Regards,

Xiaoxin Sheng