none
Use of Stored Procedure

    Question

  • I have to use a Stored Procedure that returns a table in Power Query, but in the object list of the selected SQL database I see only tables, views and functions. How can I do?

    Thank's

    Monday, September 23, 2013 12:14 PM

Answers

  • Hi Patapatty,

    Invocation of stored procedures is not supported at this point. Only tables, views and functions can be accessed from Power Query "From SQL DB" in the navigator.

    We're currently working on a new feature to enable users to send T-SQL commands to the database, which should enable the execution of the stored procedure.

    This should be available in one of our next updates, within the next few weeks. Please stay tuned to our blog (http://blogs.msdn.com/powerbi) for an update on when this feature will become available.

    Thanks,
    M.

    Monday, September 23, 2013 6:26 PM

All replies

  • Hi Patapatty,

    Invocation of stored procedures is not supported at this point. Only tables, views and functions can be accessed from Power Query "From SQL DB" in the navigator.

    We're currently working on a new feature to enable users to send T-SQL commands to the database, which should enable the execution of the stored procedure.

    This should be available in one of our next updates, within the next few weeks. Please stay tuned to our blog (http://blogs.msdn.com/powerbi) for an update on when this feature will become available.

    Thanks,
    M.

    Monday, September 23, 2013 6:26 PM
  • Thanks a lot.

    Patrizia

    Tuesday, September 24, 2013 7:29 AM