Forum Discussion

ganaa0810's avatar
ganaa0810
Regular Visitor
9 months ago
Solved

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 refr...
Need Help
  • v-ssriganesh's avatar
    v-ssriganesh
    9 months ago

    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.

AnkitaaMishra's avatar
AnkitaaMishra
Super User
9 months ago

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's avatar
    ganaa0810
    Regular Visitor
    9 months ago

    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's avatar
      AnkitaaMishra
      Super User
      9 months ago

      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's avatar
        ganaa0810
        Regular Visitor
        9 months ago

        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