incremental refresh help

[srk_powerbi]

Hi, 

i have a scenario like the fact  table does not have date field and, only has integer key in the format of 1,2,3,4, ....etc format whcih is mapped to date dimension table like below. How do i set up incremental refresh in this case. Is it possible? please suggest

dimension tabe                                                   fact table

datekey      date                                                  datekey

1               01/01/2010                                           1

2               01/02/2010                                           2

.                 ..

..               ..

3560        12/31/2020                                            3560

[negi007 · Accepted solution]

@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