Forum Discussion

Hussein_charif's avatar
Hussein_charif
Helper V
1 year ago
Solved

incremental refresh

i have a dataset that i want to apply incremental refersh to. i checked the microsoft forums  https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure   i was wonderin...
Need Help
Show and Tell
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Hussein_charif 

     

    The RangeStart and RangeEnd parameter values that you create in the Power Query Editor are used to filter the data loaded into the model before refreshing, and the incremental refresh policy overrides these time range values when you set up the incremental refresh policy and publish to the Service. So, the time ranges are automatically updated according to your incremental refresh strategy.

    Configure incremental refresh for Power BI semantic models - Power BI | Microsoft Learn

     

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

  • Akash_Varuna's avatar
    Akash_Varuna
    1 year ago

    Hi Hussein_charif , You will have to create parameters in power query here are the steps 

    • Create Parameters:

      • Open Power Query in Power BI Desktop.
      • Go to the Home tab and click Manage Parameters > New Parameter.
      • Create two parameters:
        • RangeStart 
        • RangeEnd 

    • Apply Filters in Power Query:

      • Select your date column in the table.
      • Apply a filter:
        • Date >= RangeStart.
        • Dtae < RangeEnd.
      • This ensures only rows within the dynamic range are loaded.

    • Enable Incremental Refresh:

      • Close Power Query and save changes.
      • In Power BI Desktop, right-click your table and select Incremental Refresh.
      • Enable the toggle and specify the refresh/archival periods.

     

     

Hussein_charif's avatar
Hussein_charif
Helper V
1 year ago

hi Akash_Varuna , thank you for the reply. 

by set dynamically, what do you mean exactly?

so i just set the start and end date based on my date min and max in the table and it'll automatically update?

 

Akash_Varuna's avatar
Akash_Varuna
Super User
1 year ago

Hi Hussein_charif , You will have to create parameters in power query here are the steps 

  • Create Parameters:

    • Open Power Query in Power BI Desktop.
    • Go to the Home tab and click Manage Parameters > New Parameter.
    • Create two parameters:
      • RangeStart 
      • RangeEnd 

  • Apply Filters in Power Query:

    • Select your date column in the table.
    • Apply a filter:
      • Date >= RangeStart.
      • Dtae < RangeEnd.
    • This ensures only rows within the dynamic range are loaded.

  • Enable Incremental Refresh:

    • Close Power Query and save changes.
    • In Power BI Desktop, right-click your table and select Incremental Refresh.
    • Enable the toggle and specify the refresh/archival periods.