Getting Started with Power Query. 1. Open Excel and ensure that the Data tab is visible. If it is not, you can enable it by going to File > Options > Customize Ribbon and checking the Data box.

With Power Query in Excel 365, ... Combine Files with Power Query. ... Refresh the Power Query connection to detect new files in the linked folder.