Forum Discussion

Babuhumayun86's avatar
Babuhumayun86
New Member
2 years ago
Solved

incremental refresh on a column with date format

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'...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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's avatar
JoeBarry
Solution Sage
2 years ago

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

arjobsen's avatar
arjobsen
New Member
5 months ago

A little late to the party, but I just got confronted with this problem. Apparently, yes you can.

 

Incremental Refresh will complain about not being able to find a datetime column. When added a new one, e.g. like this

= Table.AddColumn(Source, "datetime_column", each [date_column] & #time(0, 0, 0), type datetime)

it will find the datetime_column from the dropdown menu while setting up Incremental Refresh (in Power BI Online)

 

Btw: The accepted answer is not setting up Incremental Refresh. It's filtering rows in the table.