Forum Discussion
Refresh Data from Dynamics CRM
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...
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.