We are running Dynamics 365 on-premise, and have IFD enabled in order to integrate with our O365/Exchange Online server. Since I've deployed IFD, any dynamic worksheets we export have the IFD url (i.e. orgname.domain.com) in the connection properties instead of our internal url (servername.domain.com/orgname), and therefore don't work. They work if I go off of our network, but this isn't what we want. We want everything to work while people are on site, with the internal url, and then not connect if they're not on site. I tried changing the connection properties to reflect the internal URL, but just get an unspecified error. (Note: dynamic sheets from before I put IFD on still work fine.) How can I get these sheets to work, and to generate using the proper url?
*This post is locked for comments