Forum Discussion
incremental refresh help
srk_powerbi yes you would need data field to have incremental refresh.
For setting up the incremental refresh, you do need to have a table (or more) with date field(s) in it. The date field is the field that will have the impact of the partial refresh of the data. For example; Let’s say you have a FactSales table. You want to load all Sales which made earlier than a year ago just once, but everything from a year ago to now regularly. So you do need to have a date field in your table for it. Most of the time, this field can be created date, modified date, order date, publish date, etc. You do need to have a field like that as of date data type.
for more detail refer to below link
https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only
https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview
srk_powerbi yes you would need data field to have incremental refresh.
For setting up the incremental refresh, you do need to have a table (or more) with date field(s) in it. The date field is the field that will have the impact of the partial refresh of the data. For example; Let’s say you have a FactSales table. You want to load all Sales which made earlier than a year ago just once, but everything from a year ago to now regularly. So you do need to have a date field in your table for it. Most of the time, this field can be created date, modified date, order date, publish date, etc. You do need to have a field like that as of date data type.
for more detail refer to below link
https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only
https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview