The Power Query tool can be used in Excel to easily record steps taken to transform and format the data in preparation for loading into Power BI. (It can also be saved and reused to rerun the exact ...