Forum Discussion

RussellBode's avatar
RussellBode
Icon for Helper I rankHelper I
11 months ago
Solved

Date parameter not getting refresh after updating previous parameter

      Hello i m selecting Parameter select the Pay Period date shows just fine     if i change the paramter it just not working and updating dates   any thoughts    
Need Help
  • v-ssriganesh's avatar
    v-ssriganesh
    10 months ago

    Hello RussellBode,

    The Test parameter only works when visible because SSRS only auto-refreshes dependent parameters (From/To) when a visible parent changes. Hidden/internal parameters break the cascade. Remove the Test parameter, fix the "Date" dataset to return real dates (PlannedPayPeriodDateStart AS StartDate, PlannedPayPeriodDateFinish AS EndDate), set correct Value fields, enable Always refresh in Advanced tab for From/To, and order parameters correctly Pay Period → From → To. This will auto-update dates instantly on Pay Period change. Try and confirm.

    Thank you.

v-ssriganesh's avatar
v-ssriganesh
Icon for Community Support rankCommunity Support
11 months ago

Hi RussellBode,
Thank you for reaching out to the Microsoft fabric community forum.

Thanks to the update and those screenshots, your cascade is well-structured, and the dataset refresh on Pay Period changes is a smart touch. The stale dates often come from defaults not tightly matching the selected Pay Period or carrying over from prior runs.

Targeted Steps:

  • In Parameter Properties > Default Values > Edit the "Dates" dataset query. Add an explicit filter to match only the chosen Pay Period. This ensures it pulls the exact StartDate/EndDate for your selection, not a generic first row.
  • For Pay Period param > Advanced tab: Check "Always refresh." For From/To: Check "Refresh fields" and "Refresh dependent datasets when value changes." This forces a clean requery on upstream changes and blanks stale values.
  • In the "Dates" query, wrap StartDate/EndDate outputs in a standard format (like yyyy-MM-dd) to prevent parsing flips.
  • Add a hidden textbox showing current param values. Preview changes to spot if/when they update.

Republish and This should sync dates dynamically. If I misunderstand your needs or you still have problems on it, please feel free to let us know. 

Best regards,
Ganesh Singamshetty.

RussellBode's avatar
RussellBode
Icon for Helper I rankHelper I
11 months ago

Hello v-ssriganesh 

i think problem is with  date i created default values for it and it should get updated as per dataset

like below the PayrunSchdule getting refresh the pay period then date are not getting refresh

 

 

  • v-ssriganesh's avatar
    v-ssriganesh
    Icon for Community Support rankCommunity Support
    10 months ago

    Hello RussellBode,
    Thanks for the update.

    The issue seems to be that From/To dates aren’t refreshing with Pay Period changes. In "From" and "To" parameter properties > Default Values, edit the "Dates" query to filter by WHERE PayPeriods = @PayPeriod for exact matches. Enable "Refresh dependent datasets when value changes" in the Advanced tab and Test in Report Builder republish it. if issue presists please free feel to reach out us.

    Best regards,
    Ganesh Singamshetty.

    • RussellBode's avatar
      RussellBode
      Icon for Helper I rankHelper I
      10 months ago

      Hello v-ssriganesh 

      i have tried but same issue

      where is option "Refresh dependent datasets when value changes" 

       

       

       

       

       

       

      • RussellBode's avatar
        RussellBode
        Icon for Helper I rankHelper I
        10 months ago

        Hey v-ssriganesh  any update?

        when i am changing payrun schdule it update pay period then i can upodate date from and to