Connect to separate Dynamics 365 accounts
Hi, I am using Gen 2 Dataflows to extract data from our Dynamics 365 application. We use Dynamics 365 in two separate sites, US and Spain. My problem is that these are not on the same domain. They have been set up under different domains. Spain uses user@mycompany.com whereas the US uses user@mycompany.net. I have no problem getting a connection to either one from Fabric. However, I cannot connect to both. I have set up two dataflows, one for US and one for Spain. If I put in the correct credentials for the US it changes the credentials on the dataflow for Spain. This causes it to fail. The opposite is also true. Is it possible to overcome this problem? Thanks, Fergus