Forum Discussion

ankit48365's avatar
ankit48365
Regular Visitor
5 years ago

Incremental Options Disabled

Hi Guys,   I was trying to create a very simple report to reflect a daily changing value of a variable using incremental load on a date column.   as per various tutorials, i have created the star...
Need Help
v-angzheng-msft's avatar
v-angzheng-msft
Community Support
5 years ago

Hi, ankit48365 


I'm sorry that I didn't remind you of this. For the two parameters, they must be fixed and can't be customized. In other words, your parameters must also be "RangeStart" and "RangeEnd", which are case sensitive.

 

Now it's time for me to get off work. If you have other questions, I'm sorry that I may not be able to reply in time. Here I would like to say sorry first. If you have further questions, you can refer to the attached document link above, maybe the document has the answers you need, of course, I will follow up after I come back to work, I hope it is useful for you.

 

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ankit48365's avatar
ankit48365
Regular Visitor
5 years ago

Step 1: My Source (changed to a CSV file to make things simpler, earlier it was a table in excel.)

Step2:

Defined Range 

Step3: Defined filter using RangeStart & RangeEnd on Date Column. (Save and close power query editor)

Step 4: right click data field in FIELDS pane on the right and choose Incremental Refresh.

 

RESULT 

 

 

  • ankit48365's avatar
    ankit48365
    Regular Visitor
    5 years ago

    Also, i upgraded to Power BI premium plan, it wasnt giving that error, but still i upgraded to it, saved , closed and reopened, no change.