Hello @Mike Kiser ,
Thanks for the ask and using the Microsoft Q&A platform .
Put the below expression in the query and it should work .( remove white spaces )
@concat('SELECT fullname, emailaddress FROM [MercerStagingDev].[MILKY-WAYTEST\AppSQLVST4DotNetDev-R].[EmployeeVendors] WHERE employeeid =', item().employeeId)
Please do let me know how it goes .
Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members