How to append a table with a new table

[BerlinAlexander]

I work with a quite big file of over 200k rows.

Since I can't import it as one (the limit for this type od data is 200k rows), I would like to import File A with the first 100k rows, File B with with the next 100k rows, etc. and then combine them into one table.

I'm able to do that. However, I'm not sure how to then add File B, C, D, etc. to the File A. All of the files have exactly the same columns.

[parry2k · Accepted solution]

@BerlinAlexander you can append these files together in power query, transform data -> append query

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Greg_Deckler]

@BerlinAlexander - Place all of the files in a folder, use a Folder query and "Combine Binaries"

[Fowmy]

@BerlinAlexander 

UNION fuunction in DAX sould work for you, Refer to: https://docs.microsoft.com/en-us/dax/union-function-dax

If you wan to do it in Power  Query: Try Append Queries: https://exceloffthegrid.com/power-query-combine-append-queries/

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn