Forum Discussion
Helper IDate parameter not getting refresh after updating previous parameter
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.
Helper IHello 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
Community SupportHello 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
- 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