+ Reply to Thread
Results 1 to 2 of 2

Power Query Stored Procedure Invalid Identifier

  1. #1
    Registered User
    Join Date
    01-08-2010
    Location
    Arizona, USA
    MS-Off Ver
    Microsoft 365 Beta Channel
    Posts
    7

    Power Query Stored Procedure Invalid Identifier

    Hi all,

    Using Excel Microsoft 365.

    I created a Stored Procedure in Management Studio - tested - works.
    Now I am trying to call the sp from Excel Power Query and pass the parameter
    I keep getting error
    Expression.SyntaxError: Invalid Identifier
    I don't see what is worng with my M Script - do you see any problems?
    Please Login or Register  to view this content.
    Thanks,
    w
    Last edited by doofenshmirtz; 07-19-2020 at 12:16 PM. Reason: typo

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Power Query Stored Procedure Invalid Identifier

    Welcome to the excel forum.

    165 views and no answer, this indicates the question is not clear to the forummembers.

    HOW TO ATTACH YOUR SAMPLE WORKBOOK:

    Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 02-17-2020, 06:03 AM
  2. Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)
    By chullan88 in forum Suggestions for Improvement
    Replies: 10
    Last Post: 06-28-2018, 02:25 PM
  3. Replies: 0
    Last Post: 10-02-2012, 03:06 PM
  4. Edit Stored Procedure Query
    By erock24 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-30-2009, 06:36 PM
  5. [SOLVED] Execute stored procedure using ms query & vba
    By astrodon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-14-2008, 07:56 PM
  6. MS Query to read data from SQL server stored procedure
    By Souris in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-11-2005, 02:06 PM
  7. SQL stored procedure with paramters from MS Query
    By JimF in forum Excel General
    Replies: 4
    Last Post: 03-21-2005, 03:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1