Combining multiple csv files - Power BI vs Excel

Рет қаралды 11,921

Күн бұрын

In this video, I'm sharing how to combine 20+ CSV files in both Power BI and Excel. This will save hours of your time, believe me!
Join me at the Power BI Report Design Bootcamp and become a POWER BI DATA STORYTELLING MASTER! 🤓 👇
powerbiacademy.datapears.com/...
📚 Books I recommend (Power BI) 📚
Storytelling with Data - amzn.to/3WzHezG
How Charts Lie - amzn.to/3kDd3dV
Knowledge Is Beautiful - amzn.to/3ZXZK7S
Microsoft Power BI Cookbook - amzn.to/3WAZKb9
The Definitive Guide to DAX - amzn.to/3H3XrYf
Don't Make Me Think (UX) - amzn.to/3H0AdSZ
📚 Books I recommend (Business) 📚
Expert Secrets - amzn.to/3iU718g
Dotcom Secrets - amzn.to/3Xx2YOf
Think and Grow Rich - amzn.to/3iYvuck
Rich Dad Poor Dad - amzn.to/3H7kQrK
The 4-Hour Workweek - amzn.to/3ZY2KBf
Atomic Habits - amzn.to/3Wy2dDg
🚀 Check my Blog 🚀
www.datapears.com/blog
🚀 Follow me on Twitter 🚀
/ datapears
🚀 Follow me on LinkedIn 🚀
/ marapereira
🚀 Website 🚀
www.datapears.com
Chapters:
0:00 - Intro
0:48 - The use case
1:26 - Combining multiple csv files in Power BI
11:33 - Combining multiple csv files in Excel
16:00 - End
📧 contact: hello@datapears.com

Пікірлер: 24

@jawadahmadehssan6251 Жыл бұрын

I have always been combining files using the double sided arrows and it surly slows down the refresh if required. Thanks for the mcode. It really does help.

@codynik123 5 ай бұрын

that's was so helpful and solved all the issues i have been facing

@jasonedmonds8392 Ай бұрын

Thank you for this video, it was very helpful.

@jeffadam931 Жыл бұрын

Great video! Very interesting and informative. Would this work for excel files as well?

@aizidoros 4 ай бұрын

Awesome! I spend a lot of time looking for a more elegant process to do it instead of using the "Combine" button, It create a lot of unecessary steps. Thank you!

@mortenlie3898 Жыл бұрын

Love you Channel. What is each file is located is seperat folders. Can we use same setup?

@christopherreichert4751 Жыл бұрын

love your channel - muito fixe

@SandiellyOrtega Жыл бұрын

Excelente!

@albnic87 Жыл бұрын

Is there a way do add dimensions to the bar graph within that table?

@esdyas Жыл бұрын

Best practice!

@COOKINGBIRD 4 ай бұрын

Thank you.

@mateusdemarco6302 3 ай бұрын

Do the columns need to be in the same order?

@codynik123 5 ай бұрын

how do we remove empty rows that may be in some of the csv files that we are combining?

@rowanschoultz1022 Жыл бұрын

Very handy

@samitune 6 ай бұрын

How about if i have 130 excel files 10 of them has extra column "number" that i dont need ? how do i specifically edit them in Power Quary

@HachiAdachi Жыл бұрын

Thank you, Mara. A question on a performance topic: Table.ExpandTableColumn vs Table.Combine. In my anecdotal experience, Table.Combine 'appears' to work faster than Table.ExpandTableColumn when combining tables but I don't have enough data points to support the argument... Any idea?

@datapears Жыл бұрын

Not sure either to be honest! I guess it depends on your data etc

@mohammadassaf6710 Жыл бұрын

Great video! Does this apply to Sharepoint Folder?

@richardpearcephotography599 Жыл бұрын

Yes, it works great with a SP or OneDrive folder.

@fredhazelton7425 8 ай бұрын

When I try this process it doesn't just add the new file it refreshes all the previous files too. How do I set it up so that a refresh only adds the new file?

@mirrrvelll5164 Жыл бұрын

Ok good old From.Folder option. But who says that fx´s that you are getting after importing directly are "not good"? To my knowledge and use, you can tweak sample file as you wish, from promoting headers, change type and so on - in one place and it is gonna be applied to the rest of the query. ' Auto change data type is dangerous thing to do, only if you really know your data. 123 or 1.2 in a currency world can be expensive =)

@datapears Жыл бұрын

If the files require a lot of data transformations then I probably wouldn't use this method. But for "simple" files I find that this method works really well. It happened to me a couple of times using the normal folder connector, the queries became slow when I started to load dozens of files, changed to this new method and it was a huge improvement on the refresh time :)