Using Monkey Tools - Change Multiple Power Query Load Destinations at One Time!
Monkey Tools contains a collection of Sleuths who can help audit your workbooks, as well as make changes when desired.
It's great the Excel's Query and Connections pane shows that your queries have "x rows loaded", but to where? A worksheet? The Data Model? Both? One of the cool features of Monkey Tools' Destination Sleuth is that it makes this VERY obvious with colour coding. Not only that, but it also allows you to change the load destinations of MULTIPLE QUERIES AT THE SAME TIME instead of one by one as Excel's default user interface forces you to do.
Come take a look at this awesome monkey and take control of your load destinations!