The Data Report session type can be use to empower any/all users to generate reports, without having to grant them access to the actual server.
Data Report Session
Create a Data Report entry and define the connection string by either:
•Specify the connection in the entry itself
•Use a credential entry
•Inherited from a parent
•Prompt for credentials
Data Report Session - Paramaters tab
Specify the parameters by setting the name, type and default value of all parameters.
Enter the query in the Query tab, which features a SQL syntax-highlighted text box with line numbers.
Ensure that your DBA sets the proper security groups, and that each specific user(s) has access to it.