There are various ways to construct and load Power queries into your worksheet using Power Query. In the Query Options window, you can also select default query load parameters.
Select a cell of data in a spreadsheet to see if it was shaped by Power Query. If the Query context ribbon tab shows, the data was loaded from Power Query.
Select Data > Queries & Connections in Excel, and then the Queries tab. Locate the query in the list of queries, right-click it, and then select Load To. A dialogue window called Import Data opens. Select OK after deciding how you wish to import the data.