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' which is of date format.

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

 

Regards,

Babu

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.           

3 Replies

  • 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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.