Forum Discussion

eugene_novikov's avatar
eugene_novikov
New Member
1 year ago
Solved

Cannot setup incremental refresh parameters

I have both RangeStart and RangeEnd copypasted from here:  https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview#configure-incremental-refresh-and-real-time-data  to ...
  • lbendlin's avatar
    1 year ago

    If this is a semantic model in Power BI Desktop you need to now add the filter to your query using these parameters. NOTE: RangeStart is inclusive and RangeEnd is exclusive.

     

    If this is a dataflow then the filter will be added for you.

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi,Greg_Deckler ,lbendlin and omalbluw ,thanks for your concern about this issue.

    Your answers are excellent!
    And I would like to share some additional solutions below.
    Hello,eugene_novikov .I am glad to help you.
    This is my test:
    Setup Parameters

    Select the date field you need to filter (the system will set up partitions for the table based on the data in this field for incremental refreshing)

    Select RangeStart and RangeEnd to create a parameter filter.

    The range of the filter must exist in one open interval and one closed interval
    (there must and can only be one "equal to" )



    After filtering forms with parameters set, the system automatically monitors forms that can be set for incremental refreshing.

    If you want to realize incremental refresh, you must meet the following conditions.
    1. The data source supports query folding.
    If your data source does not support query folding, you can try inserting the M function in the power query
    Query folding on native queries - Power Query | Microsoft Learn
    Query folding guidance in Power BI Desktop - Power BI | Microsoft Learn
    2. the existence of date / time type table (or can be converted to date / time type of the function of the type of digital type) of the data columns, and successfully set the range parameter
    3. Successfully set the incremental refresh strategy.


    I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
    Best Regards,
    Carson Jian,
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.