Forum Discussion

unknown917's avatar
unknown917
Helper IV
1 year ago
Solved

Incremental Refresh - building historical model week by week

Hello PI folks -    Beginning to read up on incremental refresh and not sure if my scenario applies.  I have a data model that needs to be refreshed say weekly but I need to retain the data from th...
Need Help
Tips and Tricks
Tutorial Requests
  • v-achippa's avatar
    v-achippa
    1 year ago

    Hi unknown917,

     

    If the parameters are not set up correctly, this issue will occur.
    Ensure that your RangeStart and RangeEnd parameters are correctly named (case-sensitive) and have the Date/Time data type, not just Date.
    If the issue persists, please share a screenshot of your parameter setup so we can identify any mistakes.

    FYI please refer below document,

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

     

    If this post helps, then please consider Accepting as the solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thanks and regards,

    Anjan Kumar Chippa

     

BA_Pete's avatar
BA_Pete
Super User
1 year ago

Hi unknown917 ,

 

Yes, this is one exact use for incremental refresh.

You need to set up to M (Power Query) parameters that are DateTime data type, called RangeStart and RangeEnd. You then configure the incremental refresh policy directly against the specific query (table) in either the model or the dataflow and PBI will automatically update the parameter values each time it goes to refresh.

 

More info:

https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview 

 

Pete