Crate table from List of unic values from column without upload source table

[Denis_Slav]

Hi all. 

I have several huge source table (>20 GB) , and I need to create new table with unic values from [Column 1]. 

I create new query with List.Combine(Table1[Column1], Table2[Column1]) and several transformation. After Apply changes, PBI upload source tables several times: for main data and for created lists. 

Is it possible to reduce number of uploads source tables?

As a source of raw tables I use dataflows. 

[amitchandak · Accepted solution]

@Denis_Slav , Can you try this DAX and see if saves time.

distinct(union (all(Table1[Column1]), all(Table2[Column1])))

[Denis_Slav]

Thanks. Didn't think in this direction. )

But in that case I have no possibility to transform data. (

[amitchandak]

@Denis_Slav , yes, but Power query kind of works on the complete table. so once you are done with all data modeling you can try this.

[Denis_Slav]

@amitchandak Ok. Thank you. I will try.