Best way to import multiple CSV files into Power BI for analysis

[Daniel_B]

Hi There

I've searched for a few videos and tutorials on the best way to import my data but I am not sure they will work for my quite heavy datasets

I have 12 months of data with each month having roughly 200k rows of data which I need to pull together into Power BI to analyse as I cannot do it in Excel (for obvious reasons 🙂 )

Can anyone explain/guide/point in the right direction of something that can help me with this as I need to pull together an end of year report (for the first time) before the Xmas period starts

Thanks for any help/advice or links

Dan_B

[Daniel_B]

I should also mention that the columns are all exactly the same and there are quite a few of them but I could probably trim some of them if it would make the task easier/more manageable in any way

Also, the main column that links them is an entity ID which will have multiple rows as there are multiple responses per entity

Thanks again

[Tahreem24]

I'm glad that my post helped you.
I would really appreciate your Thumbs up (Kudos) also. ☺️

Good Luck!

[Tahreem24 · Accepted solution]

@Daniel_B ,

Please visit at below links for your solution:

1. https://medium.com/@wkrzywiec/getting-data-from-the-latest-file-in-a-folder-using-power-query-51dfa4...

2.https://powerpivotpro.com/2016/12/import-csv-files-folder-filenames-power-bi/

3. https://www.youtube.com/watch?v=pMQK1Zcc9jw

Don't forget to hit Thumbs up and accept this as a solution if you find it helpful!