The load options of a Power Query query define the destination of the result: a table in a sheet, a connection only or the data model. Loading into the data model avoids storing the rows in a sheet and lets you link them to other tables. A connection only is used for intermediate queries.
Example
Load the fact table into the data model and the staging queries as connection only.