Issue:

When attempting to use Edit in Excel or ODATA connection with Web Services it returns "Internal Error"


Error returned by Edit in Excel function-

image

Error returned by PowerBI:

Error returned by ODATA in browser:


Solution:

This can be caused by a duplicate name in the Web Services list in Dynamics.  Change one of the services names to ensure that each service has a unique name.  This does not affect SOAP.