Oct 02 2020 02:53 PM
Hello Everyone,
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.
-Evan
Oct 03 2020 01:04 PM
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
Optimising The Performance Of Power Query Merges In Power BI, Part 3: Table.Join And SortMerge
Tables, Numbers, Immutability And Power Query Performance
and more within.