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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.