First create a calculated field called refresh data.
Then create a table with Refresh Data in the group by.
You can get rid of headers / title to make it look cleaner.
Then create a parameter called Refresh Data with a default value of ‘Refresh Data’.
Next add a filter to all of the visuals you want to refresh on a click to be equal to the new parameter you just created.
Finally, add an action to the Refresh Button visual that will update the Refresh Data parameter to ‘Refresh Data’ (this will trigger and update).
The target sheet will be the same sheet as your visual. And you will link it to the Refresh Data field.
Let me know if that helps!