Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear All,
I have a 100k+ rows table.
I have a task to split this table by 5000 records each. It doesn't matter in what order to arrange the records. I just need to get 20+ tables that will contain 5000 rows each.
I believe there should be some way to do it smart to minimize manual work.
Please, help me!
Solved! Go to Solution.
This might be more manual than you want, but you could do this:
1) Set an INDEX number for the original table (it's in Query Editor under Add Coluimn)
2) Under Modeling, select New Table and create 20 calculated tables like so:
Table1 = CALCULATETABLE( OrigTable, OrigTab[Index] >=1 && OrigTab[Index] <= 5000 ) Table2 = CALCULATETABLE( OrigTable, OrigTab[Index] >=5001 && OrigTab[Index] <= 10000 ) etc
Hope this helps
David
Update:
I found the easier way to do it. Maybe it will help someone else.
That is why I love PowerBi 🙂
This might be more manual than you want, but you could do this:
1) Set an INDEX number for the original table (it's in Query Editor under Add Coluimn)
2) Under Modeling, select New Table and create 20 calculated tables like so:
Table1 = CALCULATETABLE( OrigTable, OrigTab[Index] >=1 && OrigTab[Index] <= 5000 ) Table2 = CALCULATETABLE( OrigTable, OrigTab[Index] >=5001 && OrigTab[Index] <= 10000 ) etc
Hope this helps
David
Dedelman_clng,
Thank you for the fast reply and help!
I didn't see the 'Modeling'. Where is it?
You gave me an idea how to do it. I'll create a filter using the Index column and will sort the DB this way. In fact, I need these tables in CSV so there is no need to create separate queries.
Thank you so much for the inspiration!
I found the modeling. I thought it was in Queries first.
Thank you!
Update:
I found the easier way to do it. Maybe it will help someone else.
That is why I love PowerBi 🙂
I didn't know that about the bin size - thanks for the tip!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |