I have a SQL query to a linked server that works fine in SQLServerManagementStudio, and I'd like to add this query to a refreshable Excel file. Usually, I am able to (in Excel) go to Data>GetExternalData>FromOtherSources>From Microsoft Query, and then copy/paste my SQL statement into the SQL free form field.
However, this does not seem to work for an OPENQUERY statement to a linked server. Are there any workarounds to this?
