Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Denis_Slav
Helper III
Helper III

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

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. 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

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

 

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

View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

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

 

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

Thanks. Didn't think in this direction. )

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

@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.

 

@amitchandak Ok. Thank you. I will try. 

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.