Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
Solved! Go to Solution.
@Denis_Slav , Can you try this DAX and see if saves time.
distinct(union (all(Table1[Column1]), all(Table2[Column1])))
@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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
87 | |
67 | |
49 |
User | Count |
---|---|
135 | |
112 | |
100 | |
68 | |
67 |