Date parameter not getting refresh after updating previous parameter

[RussellBode]

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

[Rufyda]

Hi

Enable automatic refresh for the dependent parameter:

Open the Pay Period Date parameter properties.

Under Available Values → Get values from a query, check:

“Refresh automatically when the preceding parameter changes”

Ensure its dataset uses the preceding parameter as input.

If this helps, please mark as Accepted Solution and drop a "Kudos"

[RussellBode]

Hello I dont want the avaliable value should be there for date since i cant change the date then its remains uneditable if we have avalible rather than default

could you also please specify where i have “Refresh automatically when the preceding parameter changes”?

[v-ssriganesh]

Hello @RussellBode,

We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.

Thank you.

[v-ssriganesh]

Hello @RussellBode,

Hope everything’s going great with you. Just checking in has the issue been resolved or are you still running into problems? Sharing an update can really help others facing the same thing.

Thank you.

[Shahid12523]

Enable auto-refresh or “refresh on change” for dependent date fields.
Clear any cached prompt values.
Ensure the date fields are properly linked to the selected parameter.
If needed, add a manual refresh or apply button to trigger updates.

[RussellBode]

Hello @Shahid12523 

how to do manual refresh in report builder?

[v-ssriganesh]

Hello @RussellBode,
To manually refresh a report in Report Builder, click the Run button to execute the report, you'll see a Refresh button in the toolbar click it to update the data with the latest information.

Best regards,
Ganesh Singamshetty.

[v-ssriganesh]

Hello @RussellBode, 

Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.

Thank you for being part of the Microsoft Fabric Community.

[RussellBode]

Hello @Shahid12523 

i have this steup

1. user select the pay run Schedule 

2. then  Pay periods 

3. based on  it it should update from and to date

Pay Period has the drop down by using avaliable values

date come from dates start and finish too in default values

Dates data set get fresh after every update of pay period

not sure where its getting wrong

[v-ssriganesh]

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]

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]

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]

Hello @v-ssriganesh 

i have tried but same issue

where is option "Refresh dependent datasets when value changes" 

[RussellBode]

Hey @v-ssriganesh  any update?

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

[RussellBode]

@v-ssriganesh 

tried one more thing

added test oaremetrer in between where the value of pay period na dtest i  same but if i just disable test now means hide or keep internal then  its not working may i know why?

[v-ssriganesh · Accepted solution]

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]

Hello @RussellBode,
Could you let us know if the solutions provided have addressed your query? Sharing your feedback would be beneficial for others who might face similar challenges in the future, as it can help them find effective answers more quickly.

Thank you.

[v-ssriganesh]

Hello @RussellBode,
Sorry for the inconvenience caused. Please consider raising a Microsoft support ticket for further investigation. You can explain all the troubleshooting steps you have taken to help them better understand the issue.

You can create a Microsoft support ticket with the help of the link below:
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket