Allow End Users To Manually Refresh Dataset

[Jarrod]

Hi,

In report server, we have a number of scheduled dataset refreshes however there is a requirement at times for end users to complete an adhoc data refresh. Is this possible?

Thanks,

[d_gosbell · Accepted solution]

I think if the users have Content Manager rights they can go into the scheduled refresh and click "Run Now", but that gives them a lot of other rights which you might not want them to have. You can also create a custom role which just has the Manage All Subscriptions permission and then assign that to specific users for a given folder or report.

[d_gosbell · Accepted solution]

I think if the users have Content Manager rights they can go into the scheduled refresh and click "Run Now", but that gives them a lot of other rights which you might not want them to have. You can also create a custom role which just has the Manage All Subscriptions permission and then assign that to specific users for a given folder or report.

[Jarrod]

Hi @d_gosbell,

Unfortunately, it seems as though "Manage All Subscriptions" does not provide enough permissions to refresh datasets.

[d_gosbell · Accepted solution]

---

@Jarrod wrote:

Hi @d_gosbell,

Unfortunately, it seems as though "Manage All Subscriptions" does not provide enough permissions to refresh datasets.

---

No you are correct. It looks like you also need to add "Manage Reports" in order to get the "Manage" option to appear when you click on the "..." menu for a report. Which unfortunately also gives the user permissions to delete that report - which is not ideal.

[Jarrod]

Great idea. Thanks @d_gosbell .