topic Re: Allow End Users To Manually Refresh Dataset in Report Server

Allow End Users To Manually Refresh Dataset

Jarrod — Wed, 12 Oct 2022 21:21:12 GMT

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,

Re: Allow End Users To Manually Refresh Dataset

d_gosbell — Thu, 13 Oct 2022 01:06:34 GMT

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.

Re: Allow End Users To Manually Refresh Dataset

Jarrod — Thu, 13 Oct 2022 01:17:04 GMT

Great idea. Thanks d_gosbell .

Re: Allow End Users To Manually Refresh Dataset

Jarrod — Thu, 13 Oct 2022 02:23:06 GMT

Hi d_gosbell,

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

Re: Allow End Users To Manually Refresh Dataset

d_gosbell — Thu, 13 Oct 2022 04:25:36 GMT

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.

Re: Allow End Users To Manually Refresh Dataset

ITstod-IE — Wed, 13 Dec 2023 15:22:08 GMT

Hi, I have the same issue were wo end users want to refresh data manually.
They have admin rights on the work space and are added to the Cloud data connection as owners.

But they get this "fun" error, even though it's a cloud connection to BC. Any ideas?