Query from SQL Server RRS feed

  • Question

  • I can call a simple stored procedure in a normal Excel workbook by going to the Data tab > From Other Sources > From SQL Server.  In the definition of the connection I enter the following stored procedure:

    exec [dbo].[SSRS_AUM_QueryTemplate] "3/3/17"

    This stored procedure successfully pulls data from the SQL server into my Excel workbook.

    However, when I run the same stored procedure from Power Pivot, I get an error:

    The SQL statement is not valid. There are no columns detected in the statement.

    Has anyone had success running a stored procedure from a normal Excel workbook, and then see the same exact procedure produce and error from Power Pivot?

    Monday, March 6, 2017 5:18 PM


All replies