When you close Power Query, Excel prompts you to keep or discard the query. If you want to work with the data, choose Keep. Excel copies the results of the query into a new sheet.

For now, Power Query looks empty. How to expose the Excel file’s metadata in Power Query. There’s no data in Power Query, but that’s what we want. This allows us to expose the file’s metadata.