Stop small table loading thousands of rows

[JemmaD]

Hi there,

I have a table where in M Query I pull columns from fact tables and de-duplicate to create a small dimension table.

I disabled the load of this, then referenced it in the loaded dimension table in the hope this would prevent the dimension table loading all the thousands of rows from the fact tables when I apply steps. However that hasn't worked! Is there a way I can force the new small table to simply load the de-duplicated rows and not look at all the steps that happened in the referenced table?

I hope this makes sense.

[amitchandak]

@JemmaD , First add a table, then do any action on that. Then use its reference in all other tables and create dimensions. Also the fact should be created using another reference not the first table you loaded 

example

Code of new table

let
    Source = Geography,
    #"Removed Columns" = Table.RemoveColumns(Source,{"City Id", "City"}),
    #"Removed Duplicates" = Table.Distinct(#"Removed Columns")
in
    #"Removed Duplicates"

Do not add any step in the very first table, they will executed as this is a reference