Try Microsoft Edge
A fast and secure browser that's designed for Windows 10
· You cannot include table-methods into queries and as a result you need to write and implement a custom service to get hold of this information directly in Excel.
1.) You don’t need a development licence on the machine running the script.
2.) No additional objects or contracts need to be added, deloyed or compiled in the AOT.
3.) Table-method data can be returned as part of the data download. Queries cannot accommodate this.
The advantage of WCF services is type-safety, error handling, authentication and lots of flexibility. I wouldn't give it up without much better reasons.
Agreed, and I'm not giving it up, however, in some production environments you don't have a lot of flexibility to change things once they go live. I've worked for banks that code-freeze their production environment for 3 months at a time. You would not be able to implement a WCF service in this scenario, but you would be able to use my solution to get round the problem.