Import from SQL Server Stored Procedure - first column not importing, and Order By not honored

[Nola111]

I'm using latest version of Excel from M365 on Windows, and Azure SQL Server 2017.

When I import the results of a stored procedure, it doesn't import the first column, and it doesn't import the data in the order indicated by the ORDER BY clause in the SQL Stored Procedure. When running the SP in SQL Server Management Studio, the results look exactly as we would expect.

I am connected to the database using Data-> Get Data, and from there created a connection. The Stored Procedure is being run per the method shown in this tutorial video:

I'm not getting any kind of error message that would indicate why I'm missing the first column.

Any thoughts?

 

[Nola111]

First column issue is resolved. I've opened a new thread for the Order by issue. I didn't realize I can't delete this thread when I created the other one.