INDEX is a reserved key word, you have to set it in brackets [ ] =>
SELECT TOP (1000) [Index]
,[Product]
,[Company]
,[WONum]
,[MatlNum]
,[SealMatlNo]
,[ValveOptions]
,[Misc#]
,[5]
FROM [Powerapps].[dbo].[SN_Test_DF_Idx_Full2]
order by [Index] asc