SELECT permission denied trying to import data into Excel
After reviewing your error. I tried to setup in my TEST environment and I have received an error. 

If you setup connection from Excel and after selecting specific tables to test go to connection properties. 

You will be able yo see connection string. Try to verify it with your query and see if it is changing any parameters in connection string from your query. 



Try it and let us know any progress in it.