Chris Webb gives us an update on internal join types and query folding in Power Query:
There are a couple of nice new features to do with table joins (or merges as they are known in M) and query folding in Power Query in the April release of Power BI Desktop that I want to highlight.
Read on for more information about anti-joins, semi-joins, and the ?? coalesce operator.