Forum Discussion
Incremental refresh
Hi guys im trying to configure incremental refresh on my datasets because of the data rows size. One table has over 30m rows.
So i followed the instructions of configuration of the incremental refresh.
parameters are case sensitive and need to be date/time.
its actually filtered my table but when mouse 2 click on table and choose incremental refresh it keep saying set up parameters on this table before configuring it. So i checked native thing its worked. RangeStart, RangeEnd and its date/time what else could be problem i cant really understand now.. Pls help im new here in Powerbi and jumped to little bit messy tons of datas(i mean the sizes)
Hello ganaa0810,
Thank you for posting your query in the Microsoft Fabric Community Forum.You’re very close, it sounds like most of your setup is correct. Since query folding is now working and your date column is of the correct type, the message usually appears when Power BI still can’t detect the parameters properly.
Please double-check the following points:
- The parameters are named exactly RangeStart and RangeEnd (case-sensitive).
- Both parameters are of Date/Time type, not just Date and The table where the filter is applied is the same one loaded to the model.
- The RangeStart / RangeEnd filter step is the last step in the query before loading.
- The table’s load option is enabled in Power Query.
After confirming these, close and reopen Power BI Desktop and try configuring incremental refresh again. It should now recognize the parameters.
Thanks, AnkitaaMishra for sharing your valuable insights.
Best regards,
Ganesh Singamshetty.
5 Replies
Hi ganaa0810 ,
Could you please check whether query folding is still happening on the table.
If possible, could you also share the exact error message you’re seeing?
That will help us understand the issue more clearly.I its not folding. the problem im facing is i dont have any date column so im converting the text to date in M querry will this be problem
Hi ganaa0810 , Yes, that’s likely the issue. Converting text to date in Power Query often breaks query folding, which Incremental Refresh requires. If possible, create the date column in the source and then configure incremental refresh.
