locked
Power Pivot- calling stored procedure with parameters RRS feed

  • Question

  • Hi,

    Can I use stored procedure as datasource in powerpivot. Stored procedure will have 3 parameters which needs to be passed.

    I need to fetch the parameter values at run time and pass to stored procedure.

    Is this possible?

    Wednesday, June 11, 2014 9:35 AM

Answers

  • Hello,

    Yes, it's possible. In PowerPivot Window click on "From Database" => "From SQL Server", in the Wizard select "Write a query that will specify the data to import" and then enter the call for the stored procedure, here an example for "AdventureWorks":

    EXEC [dbo].[uspGetWhereUsedProductID] @StartProductID = 1, @CheckDate = N'1/1/2015'

    Later you can modify the SP call via function "Table properties":


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Michael Amadi Wednesday, June 11, 2014 12:51 PM
    • Marked as answer by Charlie Liao Wednesday, June 18, 2014 9:47 AM
    Wednesday, June 11, 2014 10:07 AM