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 in the correct order, i.e. there query in the stored procedure ends with an ORDER BY clause. Running the procedure in SSMS returns the result in the correct order. Are there any other steps I need to take in Excel/Power Query when executing a request like this?
When I import the results of a stored procedure, it doesn't import in the correct order, i.e. there query in the stored procedure ends with an ORDER BY clause. Running the procedure in SSMS returns the result in the correct order. Are there any other steps I need to take in Excel/Power Query when executing a request like this?
