Forum Discussion
Shared Workspace Scheduled Refresh Issue
I set up a shared workspace for my colleagues and I. However I am the only one that can successfully configure the Scheduled Refresh.
The datasets are a combination of SQL databases and SharePoint lists. All of which my colleagues have the correct access to.
It means that if i am on leave and an issue occurs with the data refresh, then they are powerless to stop it.
7 Replies
Hi Sotirios,
From your description, it seems that the report resides on a app workspace, right?
You can grant the app workspace member edit permission. When you are on leave and the schedule refresh is failed, the app workspace can take over the dataset settings, and configure gateway and set schedule refresh again.
Best Regards,
Qiuyun YuThanks for your reply v-qiuyu-msft
We have tried your suggestion previously and cannot get it to work. My colleagues appear to have the correct permissions for the data sources but cannot get it to work.
Is there anything else we should check?
It sounds like they have permission for onsite data but not to edit in PowerBI. In my group workspaces, as the owner, I have to assign rights to edit or refresh. I do this by clicking the elipse beside the workspace name and selecting Members. This takes me to the group page where I can click the elipse beside the member name to give this shared ownership of the dataset so that they can edit and/or complete manual refreshes. If you use the data gateway, you may also have to make sure they have permissions in the gateway as well.
