Forum Discussion
Date 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.
Hello v-ssriganesh
i have tried but same issue
where is option "Refresh dependent datasets when value changes"
Hey v-ssriganesh any update?
when i am changing payrun schdule it update pay period then i can upodate date from and to
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-tickettried 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?
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.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.