14.4 Append multiple Excel files from a folder in Power BI (Power Query) | By Pavan Lalwani

[@PavanLalwani]

🚀 Calling all data enthusiasts! 💼🌟 👉 Discover the power of Power BI with our Specialization course at a jaw-dropping 50% off! 🔗 Grab your discounted spot here: learn.pavanlalwani.com/courses/Power-BI-2023-63a05686e4b0a7b1ab4dfc8d 💥 Level up your analytical game and supercharge your career with the Power BI DAX course. 💯💼 🔗 Explore the possibilities here: learn.pavanlalwani.com/courses/Power-BI-Dax-634fa813e4b0c08ed56c9919

[@0pusdejazz]

Thanks Pavan - you are brilliant and very explanatory👍👍👍

[@IrfanKhan-wv8rh]

Sir.. Dil jeet liya.. what a explanation.. Thank you sir!

[@sockkhimpah6926]

Thank you so much, Pavan! I'm impressed with your video, crisp and clear, straight to the point. Truly amazing!!!

[@PavanLalwani]

Thank you so much !!

[@nirbhaymani961]

It’s really helpful video

[@krishnakantapanda6835]

Useful information

[@shaikhasif9489]

Great @Pavan

[@chatkara7344]

Explained in very simple way, great Pavan!!

[@NashwaAlsinani]

Hii, this is very helpful you really save my day. thank youuu

[@amanbhargavaofficial]

Thank you😊😊😊😊😊😊😊😊

[@Ehabalsharif]

Thank you so much. The video is so helpful and explained in such a nice and simple way. This will save me so much time.

[@PavanLalwani]

You're very welcome!

[@bsai1070]

awesome clear and precise

[@geraldsahd3413]

Thanks Pavan! Everyone has a video on CVS but Excel is a little tricky

[@PavanLalwani]

My pleasure

[@RaviKumar-gz9my]

Very Nice Pavan. Appreciate

[@PavanLalwani]

Thank you !!

[@AlterAgs]

Thank you.

[@jailsonj.martins5355]

Nice, Very good,

[@harikrishnareddy2700]

How to do the same from the sharepoint folder? Pls do a video

[@manishlalsah8075]

Thankyou sir ..

[@checkmateatnet]

at 2:43 when you click on Binary at "content" column file size is displayed at bottom, when i try its directly navigating to that file /section. Do we need to change any setting for it?

[@checkmateatnet]

With keyboard arrow key its working

[@anuragshrivastava7855]

is there any course on power bi including dax advance level

[@kunicagupta9659]

@PavanLalwani suppose we have multiple tables in particular first sheet of excel then is it possible to import each table from that single 1st sheet in powerbi

[@PavanLalwani]

Yes

[@gauravkhurana4807]

Can you show how to auto refresh on the Power Bi service online?

[@vasu4ug]

Happy Birthday Sir..

[@avantikaatul]

Sir, @5:12 Custom.Name and Custom.Item are same (have the same name), what's the difference between them?

[@maammagarivanta7841]

Hi Sir - How to use this formula =IFERROR(IF(SEARCH("FCS",R2),"FCS") in power query

[@TheWestcoastrangers]

Pavan, This was super helpful. I am appending raw csv files from a LinkedIn export. It is always in the same format, but it is not in tables. Do you have any advice about how I might append that data?

[@George-kg7cd]

Hello Pavan, how could I refresh or load a chosen table? Because when I refresh or load the new data, it refreshes all the tables. Thank you!

[@aditimanojkumar5043]

When I do this..file append with heading.i ma appending Excel file...plz suggest

[@ritujain7559]

Hi Pavan If i have to add columns in the table how do I get them in power BI after refresh of the data

[@PriyankaBhosale-u5e]

Hello, I am trying to load folder from one drive but at expand stage( 4.28) it's just loading and not moving further. Could you please help

[@AyushDubey205]

Hi Pawan, Clean names didn’t appear post selecting the data rather i had to promote headers which led to error. Please advise

[@chanchalarya983]

can we add excel sheet in power bi with calculation and formula?

[@pramodgahtori4186]

I have 4 files and in all files asset id is common for all but asset status is different and due to this duplicate assets are showing but when trying to remove duplicate only one file having completed data and other date data showing less number of asset id, pls help on this

[@kumargaurav5644]

Why didn't we click on Combine and Transform data as we did in the case of CSV files?

[@MeRajiCrazy]

Yes same doubt I got

[@rpatel4698]

Do you have any video that help me "count on of consecutive days and no of sequence" in power query. Thanks

[@vedavathit.mahadeva237]

Hi Pavan, while appending multiple files of similar format when I added custom column in new column I got text as error. The file format is 1-16 rows is basic details of customer and from 17th row I have table format in all the files. What could have gone wrong. Thanks a lot for your excellent videos. Could you please let me know on this.

[@shahjayesh]

Hi. What if first I want to filter n group some data and want each file from folder to go through similar process before going into table?

[@Parimala_p]

Sir when appended the folder i am getting data source error how to rectify please help

[@raghunadhamara6243]

Hi pavan sir can we have a session on power pivot options in power bi please

[@syednabeelali6350]

What is purchase price of Power BI ???

[@smmahiuzzamanmahin757]

I have another query. Each excel file contains multiple sheets with different headers. (the contents are not in a table and I also don't want to convert it as table in excel). How can I set the first row as the header for each sheet while appending in Power Bi?

[@a1brabhay333]

Plz ..provided file which is u r explaining in video

[@PavanLalwani]

Link in description

[@amritajain1111]

Hi, can anyone tell, I have created custom column, but inside column, "error" is there not "Table".

[@paramjeet975singh3]

thanx sir ,,,, when you type excel. then automatically shows workbook option,,,,,, but in my case i have to type completely Excel.Workbook why ?? thanx

[@jasminedeshmukh8300]

When I click ok after clicking content in excel.workbook the custom column created is showing error.

[@DaughterOfGodJG]

same

[@madhubachu7392]

Sir, Can you upload Power Pivot videos

[@pravinkrishnan4184]

How this video differs from 14.1 ?

[@shikhabhati7524]

steps applied but when i am applying them to enter in power view its showing error

[@DaughterOfGodJG]

same here....getting error

[@DaughterOfGodJG]

put the ([content])

[@izharkhan71]

How to combine multiple excel file from multiple folders into power BI?

[@jaitiwari241]

you did not share the file.. shared pbix

[@syednabeelali6350]

How to and where to purchase power BI

[@syednabeelali6350]

Please reply

[@syednabeelali6350]

How to purchase and where to purchase power BI

[@nicky5830-g1r]

Sir this session I can't understand 😔