Allow Team to request or refresh report manually

[shaebert]

Hello, I have some reports that reschedule daily, but I need them to be refreshed on-demand as my team needs to pull the most recent version of the report from time to time. Right now, my team has to keep asking me to refresh the report as they don't have permission to access the dataset ( and I don't want them to).  Its really annoying to have to keep going into the report and manually refresh. Is there some way to make it easy for my team to refresh the dataset without giving them permission? Maybe Power Automate could provide a solution? 

[shaebert · Accepted solution]

I found a solution here: https://www.youtube.com/watch?v=t2nCOGYbopI via Power Automate. That video shows how you can create a link/button to trigger a flow that can then refresh a dataset.