Before getting onto the tips, it's important to understand that "close & apply" button will run all the steps on each table we have added in the edit queries or transform data window. This means that...
Updated 5 years ago
Version 4.0
These are excellent recommendations. In addition, I recommend this article with ETL Power BI best practices.