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