How to create and populate a table in Microsoft Excel’s Power Query Your ... Instead, we’ll use M code to generate the dataset. On the Home tab, click Advanced Query Editor in the Query ...