Import data from MSSQL in PowerPivot via strored procedure RRS feed

  • Question

  • Hi,

    I would like to import data(a View) in PowerPivot with a stored procedure. I choosed a MSSQL database and connected. After that I typed in the name of the stored procedure and tested. I got data, but  when I wanted  validate and finish I got the failure message with this text: The SQL statement is not valid. Can not be detected in the instruction column.

    Thank in advance


    Thomas Vincze

    Monday, September 22, 2014 11:05 AM


  • Please check this below link:


    Nag Pal MCTS/MCITP (SQL Server 2005/2008) :: Please Mark Answer/vote if it is helpful ::

    Tuesday, September 23, 2014 8:57 AM