Figure B Load the Excel data into Power Query. Once you’ve disabled OneDrive, you’re ready to launch Power Query: 1. From inside the Excel workbook with all the tabs, click the Data tab. 2.

You can enter data into a Microsoft Excel sheet or run a bit of M code in Microsoft Excel Power Query when you need to create a table.