I have created a spreadsheet that displays data from 4 tables within our Dynamics 365 CRM site. I have used merges, filtering, and column removal to consolidate the 4 tables onto 1 sheet. My issue now is every time I select "Refresh All", it takes over an hour to re-load all of the data (about 300,000 records). I have tried using suggestions for other postings to speed up the load time, but haven't had any luck this far. Any input would be greatly appreciated.
Performance is never only technology, it's partly the art since for each concrete case it will be concrete solution. However, there are some recommendation to which is better to follow. Chris Webb had few series of post related to this topic, I'd recommend to check them. First I found