This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 13%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
billionec.PNG Hi, when working through SQL statements in Power Query I saw this error code pop up even when the actual error changed (ie syntax vs arithmetic error). I downloaded and searched through the Windows_Protocols error documentation, but it only goes up to 50,000 and mine is -2,146,232,060. Can't download SSMS or the SQL Checker as seen here (https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/network-related-or-instance-specific-error-occurred-while-establishing-connection?view=sql-server-ver15)
I've attached a screenshot as well, danks.
Check a similar problem and visit that community too:
Thanks for the link but this isn't it. Their issue has a different error message (Couldn't establish connection with server) associated with the same ErrorCode. I want to know what that specific errorcode/error code means since all my queries have that regardless of cause.
That negative error code looks like something that comes from the Windows/Excel side of things. The error number from SQL Server is 102 (Incorrect syntax.)
I would just ignore that negative number.
Hi @Chippy
As the error message says, there is syntax error in your SQL statement.
Try this modification:
SELECT
AUFNR AS [Order Number],
PLNBEZ AS [Material Number],
GLTRP_SIMP_DT AS [Basic Finish Dat],
GAMNG AS [Order Quantity]
FROM bv.AFKO
Best regards,
Cosmog
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Hello Cosmog,
I'm given the same error regardless of brackets, quotation marks, etc. It seems to me that the syntax within this box isn't T-SQL because the syntax in the MS documentation cannot be copied into here.
aufnr.PNG I've attached screen clips too, thanks. plnbez.PNG
All images you have posted do indeed have syntax errors in the SQL code.Try the SQL code in Cosmog's post. There was actually a syntax error in his code as well, a missing comma, which I took the liberty to correct.
Thanks for the input, Erland. I tried both ways (with and without that last comma) but no dice. Some of the changes seem awfully far from the T-SQL rules and yet it is confined to Power Query Editor. I just don't know how to explain my struggles other than "it's off the base syntax of T-SQL". 8-14EoD.PNG eod2.PNG
In the screenshot you are not running Cosmog's query, but something else which appears to be your own invention, and which certainly is not legal SQL. Remove this "AUNFR:" etc. It does not belong in the syntax.
The Power Query editor itself is nothing special. I just accepts the SQL Statement and runs against your chosen data source. And you send that data source some syntax it does not like, you get an error back from the data source. Which is exactly what is happening here.
The syntax to query data is like:
SELECT
[Column1] AS [Alias1],
[Column2] AS [Alias2],
[Column3] AS [Alias3]
FROM Table
If the column name or alias has a space or colon in it, you need to frame it in square brackets.
So I actually cannot alter anything inside the tables as Alter Table does not function, nor does Sp_rename which led me to ask about checking DB permissions where I am.
But regardless, I'd still like to know what that error code is and why it always appears. How could it be negative and in the billions?
So I actually cannot alter anything inside the tables as Alter Table does not function, nor does Sp_rename which led me to ask about checking DB permissions where I am.
Why would you alter or rename anything? No one has suggested this.
But regardless, I'd still like to know what that error code is and why it always appears. How could it be negative and in the billions?
The error code with the negative number means "data source reported an error". Look for the rest of the message to understand what the error actually is.
Many error codes in Windows APIs have the high bit set. Which makes them very big negative numbers.
Well you did say to remove the AUFNR: prefix, but I can't as it comes from a SAP table. So to remove it, I'd need to give it an Alias, alter the table to alter the column name, or use sp_rename (which I admit I don't understand). But only the alias works for me (in addition to SELECT, FROM, JOIN, UNION, ON, WHERE,).
Sorry if I'm not too clear; I've been tasked with writing statements that have name changes, data type changes, and merges/unions. It seems perhaps I wouldn't have internal permission to alter the table as needed. I'm trying to figure out what is incorrect with my setup on my own but don't even have the access needed to prove that to the people I work for. Feels like a Catch 22 that I have to solve.
Thanks for the explanation on the error code though; I won't worry about the number then and instead solely focus on the syntax/data source error text.
So no one where knows what your actual tables and columns are called, so we can only make guesses.If the column is indeed called AUFNR: (PK) Order Number, you need to say
SELECT [AUFNR: (PK) Order Number] AS [Order Number],
and same for the other columns and the name of the table / view in the FROM clause.