Incremental refresh

[ganaa0810]

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)

[AnkitaaMishra]

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.

[ganaa0810]

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 

[AnkitaaMishra]

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.

[ganaa0810]

I changed source date column date text to date type. And the query is folding on native thing. But its keep saying set up parameters... The parameters checked required checkbox, its date type, and its in advanced editor

let
Source = PostgreSQL.Database("powerbi.db.e-mart.mn", "postgres"),
public_STK_SKUDD = Source{[Schema="public",Item="STK_SKUDD"]}[Data],
#"Filtered Rows" = Table.SelectRows(public_STK_SKUDD, each [YYMD] >= RangeStart and [YYMD] < RangeEnd)
in
#"Filtered Rows"
tottaly confused now pls help

[v-ssriganesh · Accepted solution]

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.