Seeing transformed data in Power Query Editor does not tell you which worksheet contains the result. A workbook can hold a query without displaying its output in the grid where you expected to find it. Locate the existing query before importing the same source again.

These steps use desktop Excel for Windows, including Microsoft 365, Excel 2024 and Excel 2021. Save a working copy and note the intended result: a visible worksheet table for inspection, or data used through the workbook's Data Model. Those are different destinations.

Inspect the query's own load choice

In Excel, open Data, Queries & Connections and select the Queries tab. Find the query, right-click it and choose Load To. The Import Data dialog controls how and where to load its result, including whether to add it to the Data Model. Microsoft notes that not every query is loaded to a worksheet.

In Power Query Editor, Home, Close & Load loads to a worksheet; Close & Load To exposes the destination choices. If Load To is initially unavailable, Microsoft describes first using Close & Load and then reopening Load To from Excel's Queries & Connections pane. A valid query without errors is a prerequisite for loading its result.

Before changing anything, record the current destination choice. If the workbook was designed around a model-backed report, the absence of a raw-data sheet may be intentional. Confirm the purpose with the workbook's documentation rather than assuming a worksheet was deleted.

Prove the destination with a recognisable result

For a worksheet result, choose an appropriate empty destination and inspect a known record after loading. Check both its identifier and one transformed value. A new sheet name alone does not establish that you found the correct query output.

For a Data Model result, check the report or model table that is intended to consume it, using a known record or deliberately small sample. Do not judge success solely by the presence of a worksheet tab.

Finally, distinguish the source table from the loaded result in their names and workbook notes. Record which query produces each report and where that result belongs. This gives the next editor a route to the existing data instead of another import that duplicates the workbook's maintenance burden.

Sources: Microsoft: creating and loading Excel queries; Microsoft: queries and connections.