incremental refresh on a column with date format

[Babuhumayun86]

Hi Team,

I am trying to configure incremental refresh on a table. I have configured 'RangeStart' and 'RangeEnd' parameters. Now I want to apply filter using these parameters on a Column named 'Date' which is of date format.

Can you please help us how to do incremental refresh if it is in Date Format.

Regards,

Babu

[v-stephen-msft · Accepted solution]

Hi @Babuhumayun86 ,

With the RangeStart and RangeEnd parameters defined, you apply custom date filters on your table's date column. The filters you apply select a subset of data that's loaded into the model when you select Apply.

For example

The RangeStart and RangeEnd parameters, which must be date/time data type, filter table data based on the date column. The date column is also date/time data type. 

If you want to learn more about it, please refer to

Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Learn

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[JoeBarry]

Hi @Babuhumayun86 

Is it possible to create a duplicate of the date column and format it as datetime and then use this column for incremental refresh?

Thanks

Joe