locked
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


    Thomas Vincze

    Monday, September 22, 2014 11:05 AM

Answers

  • Please check this below link:

    http://social.technet.microsoft.com/wiki/contents/articles/15542.powerpivot-troubleshooting-sql-statement-is-not-valid-there-are-no-columns-detected-in-the-statement.aspx


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

    Tuesday, September 23, 2014 8:57 AM