Excel Reporting using Excel Services RRS feed

  • Question

  • Hi,

    I have created a excel report by creating connection to Project Server Reporting Database and replace the table with SQL query and changed the commend type from Table to SQL. Provided SSID Excel Service authentication, Exported the connection file to Data Connections in BI Center.

    It works fine. But I don't want the users to SQL query and wanted to use Stored Procedure instead and replace the excel query with Execute Stored Procedure query. I am getting 'The Execute permission is denied' error.

    how to use Stored Procedure for Excel Reporting.

    Thanks in Advance


    Thursday, April 16, 2015 3:58 PM


All replies