Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Cannot set up Incremental Refresh

I am not able to set up an incremental refresh as shown in the Power BI walkthrough  (https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview)

I have created the parameteres and filtered the data using the parameters but when I right click on the table and select "Incremental Refresh" all of the options are greyed out. (See below) It says that I need to set up parameters but I have already did that. (see second image below)

 

Need Help
Show and Tell
Tutorial Requests
  • v-xiaotang's avatar
    v-xiaotang
    5 years ago

    Hi Anonymous 

    1. you should use parameter RangeStart and RangeEnd, instead of using Start Date/ End Date.
    2. you need to apply the 2 parameters RangeStart and RangeEnd to the specific table in Power Query Editor, then select "Incremental Refresh" of this table in Power BI Desktop.
    FYI:
    https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure

     

    Best Regards,

    Community Support Team _ Tang

    If this post helps, please consider Accept it as the solution✔️ to help the other members find it more quickly.

3 Replies

  • parry2k's avatar
    parry2k
    Super User
    5 years ago

    Anonymous parameter names need to be called exactly RangeStart and RangeEnd

     

    Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

  • HashamNiaz's avatar
    HashamNiaz
    Solution Sage
    5 years ago

    Hi Anonymous !

     

    Please refer to the documentation part where it says:

     

    Table data is filtered by using Power Query date/time parameters with the reserved, case-sensitive names RangeStart and RangeEnd.

     

    Parameter names need to be exactly the same as mentioned in the MS Docs.

     

    Regards,

    Hasham

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    5 years ago

    Hi Anonymous 

    1. you should use parameter RangeStart and RangeEnd, instead of using Start Date/ End Date.
    2. you need to apply the 2 parameters RangeStart and RangeEnd to the specific table in Power Query Editor, then select "Incremental Refresh" of this table in Power BI Desktop.
    FYI:
    https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure

     

    Best Regards,

    Community Support Team _ Tang

    If this post helps, please consider Accept it as the solution✔️ to help the other members find it more quickly.