cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors