This is a frustrating moment that many Power Query newcomers will recognize, and it points to a deeper truth: Excel's data tools were never designed to be intuitive. The user here has done everything right, imported a PDF, transformed the data, clicked Close and Load, and got nothing. No query appears in the Queries & Connections pane. The editor shows the work, but the spreadsheet stays empty. That is not a user error. It is a design failure in how Excel surfaces its own features.
The root cause is almost certainly that the query's load destination was never set or was accidentally cleared. Power Query, for all its power, relies on a hidden property called "Load to" that determines where the result goes. If that property is blank or set to "Only Create Connection," Close and Load will close the editor but leave you staring at an empty sheet. The user's queries are alive in the editor, but Excel has no instruction to place them anywhere. This is a common trap: the tool assumes you know about a setting that is buried in the right-click menu of the Queries & Connections pane, a pane that, for this user, is not even showing the query.
What this means in practical terms is that the user needs to reopen the Power Query Editor, select the query, and check the "Load To" settings under the Home tab. Choose "Table" or "PivotTable Report" and specify a worksheet. Then Close and Load will actually deliver the data. It is a small fix, but it requires knowing that the problem exists. Excel does not surface an error message because, technically, there is no error, just a missing instruction. For someone new to Power Query, that silence is more confusing than a red alert.
Our take is straightforward: Excel's data transformation tools are powerful, but they are not yet accessible. A tool that hides its own output destination and offers no feedback when that destination is empty is a tool that punishes exploration. The user's instinct to open the editor, transform the data, and click the big button is exactly right. The tool should meet that instinct with clear guidance, not a dead end. Until tools like Power Query become more transparent about their defaults, users like this one will keep hitting walls that are not their fault. The solution exists, but it should not require a Reddit post to find it.