Optimization of Power Query scripts execution time
Caching of queries in Power BI and Excel Power Query is explained in detail in Chris Webb’s BI Blog Referenced Queries And Caching In Power BI And Power Query
- Table.Distinct One of the side-effects of using Table.Distinct() is that it adds a primary key to the table. Yes, tables in Power Query can have primary keys – the Table.AddKey() function is another way of doing this.
- Table.AddKey
- Table.Buffer
- JoinAlgorithm - need to test it a little bit more