Question

You are building a Power Query solution in Power BI Desktop. A query named 'RegionLookup' is referenced by three other queries during transformation steps, but 'RegionLookup' itself should not appear in the data model as a table because it is only an intermediate staging step. When you refresh, you notice 'RegionLookup' is being loaded into the model unnecessarily, increasing model size and refresh time. What should you do to keep the referencing queries working while preventing 'RegionLookup' from loading into the model?

Accepted Answer

Right-click 'RegionLookup' and clear the 'Enable load' option so it becomes a staging query that is not loaded to the model.

Answer

Delete the 'RegionLookup' query and paste its steps into each of the three referencing queries.

Answer

Set 'RegionLookup' to 'Include in report refresh' = Off so it stops loading.

Answer

Hide the 'RegionLookup' table in Model view so it no longer consumes model storage.