We have a report consisting of multiple queries, and we would like to limit the ability of users so that they can only Refresh All of the queries, not just individual queries in the report.
Problems have arisen due to users using the drop down menu next to the Refresh button and selecting an individual query to refresh, not realising the impact which then causes the rest of the report data to be inconsistent. We could look at ways of restructuring the report, but this is a lot more work.
The report is called via another report passing in paramaters, so it is still important for the users to have Refresh rights, but we need to ensure that they are refreshing all or nothing.
BI 4.1 SP2 P5.