Forum Discussion

unknown917's avatar
unknown917
Icon for Helper IV rankHelper 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

     

unknown917's avatar
unknown917
Icon for Helper IV rankHelper IV
1 year ago

Still working through trying to set up incremental refresh.  I have set up parameters, but it still says I don't have them set up when I attempt to set up incremental refresh

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
1 year ago

 

Are you able to share screenshots of what you're seeing please? Pics of your parameters as they show in the query list, pic of the error you're getting etc.

It's difficult to advise without being able to see/understand exactly what your setup is.

 

Pete