We are in the process of converting from CRM 2011 to D365 (Cloud). We have purchased the D365 connector, however we have noticed it's very slow. A simple comparison would be it take 30 minutes to pull a total of 111K rows of data from miscellaneous tables using FETCHXML. On a nightly bases I pull 11 million rows in 80 minutes. Am I missing something or is the fetchxml really this slow vs. on prem SQL DB.
