Forum Discussion

SLI's avatar
SLI
Icon for Helper IV rankHelper IV
7 years ago
Solved

Problem with incremental refresh on power bi premium

Hi everyone I have a problem with incremental refresh on power bi premium. I have set an incremental refresh on my power bi desktop (the aim is to refresh data of 2 last days) . on power bi desktop...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    hi SLI 

    Do you have a specific date column defined as LastUpdated date and specified the incremental policy in a the relevant table? Also make sure you have loaded the hisotrical data and refresh rows in the last ( XX) days.  detect data changes also critical to LastUpdatedDate changes. 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

hi SLI 

How did you generate the "dataLastUpdate" column? I am having issues with duplicated values and my date.time column is comign from source system.

 

Thanks

SLI's avatar
SLI
Icon for Helper IV rankHelper IV
6 years ago

Hi Anonymous 

 

Sorry for the delay of my answer i've created a new column named "DateOfUpdate" and update this column with the datetime of the insertion of data

This solved my problem

the column has been added directly on the datawarehouse and data updated by SSIS

 

best regards