'utf-8' codec can't decode byte ERROR when querying data
I fixed the problem adding character_set 'UTF-8' when creating foreign server. 
Example:

CREATE SERVER myserver 
FOREIGN DATA WRAPPER tds_fdw 
OPTIONS (servername 'localhost', port '1501',msg_handler 'notice', database 'mydb', character_set 'UTF-8');