Cannot set up Incremental Refresh

[Anonymous]

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)

[v-xiaotang · Accepted solution]

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.

[HashamNiaz]

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

[parry2k]

@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.⚡