Forum Discussion

JemmaD's avatar
JemmaD
Icon for Helper V rankHelper V
2 years ago

Stop small table loading thousands of rows

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.

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    2 years ago

    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