Incremental Refresh without date

[ahmedshalabyy12]

Dears , 

I have  a question  :
 if i don't have date column in my fact table for example so can i setup incremental refresh ? 

Thank you  

[v-saisrao-msft]

Hi @ahmedshalabyy12,

Have you had an opportunity to review the solution we provided by @collinq? At this time, it is not possible to set up incremental refresh without a date column.

Thank you.

[ahmedshalabyy12]

yeah thank you  

[collinq · Accepted solution]

Hi @ahmedshalabyy12 ,

To do incremental refresh you must have a DateTime field.  You cannot do incremental refresh without it.  And, when you set up the incremental refresh you pick the field that you want to use.

This is an article that might help you out:
Configure incremental refresh and real-time data for Power BI semantic models - Power BI | Microsoft...