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 

 

 

According to the warning in the above screenshot, you have not configured the required parameters properly

 

Please refer to the reference document below for details

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

https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure

https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-xmla

https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-troubleshoot

 

 

Is this the result you want? Hope this is useful to you

Please feel free to let me know If you have further questions

 

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

Appreciate you quick response, as i mentioned in my post, i did create the range, below is the screen shot, and there only one table in my report. then why it is not picking the range.

 

  • 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.