Combine data from multiple Excel sheets or CSV / Excel files - Power Query - Power BI

Combine data from multiple Excel sheets or CSV / Excel files - Power Query - Power BI - ETL

Рет қаралды 7,678

Күн бұрын

#consolidate #msexcel #datacleaning
Learn the 11th rule of clean data. Combine data from multiple files (Excel / CSV) and also from multiple sheets using Power BI (Power Query). Save hours of manual work.
Learn how to use Power Query in Excel and Power BI to perform quick and efficient data analytics. Automate ETL without writing macros.
Read articles by Dr Nitin Paranjape about Excel and #powerbi
efficiency365....

Пікірлер: 13

@halfbit 3 жыл бұрын

Thank you! Very helpful.

@efficiency365 3 жыл бұрын

Thanks. Check out my Power BI articles efficiency365.com/tag/power-bi/ and videos kzfaq.info/sun/PL-UPeBWRvha1JbeRoLpkkyymuq_foB9V- Also see my Power BI course on Udemy hi.switchy.io/22B1

@mAdSk1llz86 2 жыл бұрын

great,easy to apply video, thanks!

@efficiency365 2 жыл бұрын

Thanks. Explore more PowerPoint videos on this channel kzfaq.info/sun/PL-UPeBWRvha2BcZLD_3YtbOod2nw7B8Qx Check out my PowerPoint blog articles: efficiency365.com/tag/powerpoint/ Check out my My Udemy courses Excel to Power BI s.efficiency365.com/upbi Pivot Tables s.efficiency365.com/upt Learn 130 essential efficiency best practices - read my latest book - s.efficiency365.com/bk Let me know if you want me to cover any specific topics as well. Cheers. Dr Nitin (doc) Paranjape.

@minitachoudhary9185 2 жыл бұрын

Can you please show how can we combine multiple excel files to multiple excel sheets of single excel file ..like if we have 50 excel files to be combined to 50 excel sheets of single excel file..is it possiblle ?

@efficiency365 2 жыл бұрын

That is not a good idea. What is the benefit?

@Shyam_A 4 жыл бұрын

Hello Sir, is there any way to convert all sheet in single excel into the table at once or I have to do it one by one for all sheets

@efficiency365 4 жыл бұрын

One by one.. Little powerquery code can be used to automate

@GGgymnastgirl 2 жыл бұрын

@@efficiency365 Thank you sir, Can you demonstrate that? Thank you!

@mahmoodhussain4065 4 жыл бұрын

What if i have multiple excel files with multiple sheets and i want to get data from one sheet in all the files?

@efficiency365 4 жыл бұрын

You will have to use both methods in two steps in Power Query. First step get sheets from each file. Second step append all of them. Till then Disable Load for all.

@SmartTechCAMP 4 жыл бұрын

Sir, May I reuse your video, I want to translate in other langauge with my voice, and upload it KZfaq, I am asking this question because in your description this video for Creative Commons

@efficiency365 4 жыл бұрын

Please send me a mail on nitin@maxoffice.co with details.