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

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.