COMBINE FROM FOLDER in Power BI | What to do when new columns don't show?!

Make combine from folder more future proof by automatically incorporating new columns added to any of the files in a folder.

--------------------------------
📊 TRAININGS 📊
---------------------------------

---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
0:00​ Intro
0:48 When combine from folders fails
1:37 Combine from folder - Standard scenario
3:30 Adding new files with new columns
4:13 Adjust combine from folder so that new columns are included
09:24​ End

---------------------------------
😍 JOIN 😍
----------------------------------

---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------

* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!

Thanks for being a part of this channel and all your support! 💪 🙏

#HowToPowerBI​ #PowerBI​ #DataTraining​
#powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX

[Zakehonest]

You make it easy to follow, step by step and in simple basic terms. Thank you!

[CalebHarrison-fzlu]

Very easy to understand. Thank you for the help

[TimePasser]

my brother and my friend.. I cant thank you enough.. this is exactly what i needed..

[veenarahul]

Wow Excellent video. I have searching for this everywhere. Finally I got it. Very easy to follow. Thanks much for uploading it.
Could you please share how we can combine files from a sharepoint folder please?

[SolidSnake]

I have been looking for good advanced PowerQuery lessons. Your videos are just what I need. Thank you!

[istiaqjahanshuvo]

Just becoming your fan day by day! Amazing contents! Thank you so much!!!

[kartik-wijv]

You are Awesome... in both Content and Presentation.. Keep Sharing.. 👍....

[lh]

Awesome Video. I searched everywhere for an easy to understand, quick solution. Great Job on the explanation

[sujawahab]

Thanks for this .. you have no idea how much this helped me to one of my work assignment. i will subscribe and check all your videos

[leticiacoelho]

Great content, very easy to follow! Thank you!!

[onkartanwade]

Hi Sir, thank you for this solution I have been stuck for a long time to figure it out. Great relief.😅

[DanGibson-iu]

Transform from Sample File -> Change number of columns in the M-code

[mubangizijulius]

Thank you so much. I combined more than 10 workbooks following your steps yes it worked but it is too slow on loading and refreshing. It can take almost an hour. what should I do because this technique had worked for me? Your guidance will be highly appreciated

[stevegisselman]

Always the best tutorials Bas! Thank you for all you do!

[narayanankannan]

Your videos are a good reference point!

[ChrisSmithFW]

This is a fantastic solution and perfectly presented. Kudos! Thought you solved my problem but this solution doesn't work with CSV's. Looking for the same but for CSV's.

When I perform the [Transform File] steps, I see that the new CSV is imported but still the new fields are not.

UPDATE:
I've been working on this all day and finally have it working properly. For some reason, as mentioned earlier, when I perform these steps, the source CSV does not include the new fields/columns from [Transform Data]. No matter what I tried, I could not get the test source file to show the new fields by performing just [Transform Data]. Because it was not displaying the new fields, I opened the Advanced Editor from "Transform Sample File, " located the "Columns =" code and aggregated the number of new columns to the existing "Columns =" value.

I then went back into the Query file, went to the "Data" Applied Step and clicked on the test file. Voila, the new fields are there.

Appears the takeaway, at least for me, is to update the total number of fields included in the file containing the largest number of fields before performing these steps...or at least getting them to work properly.

Thanks so much for the help on this. Been wracking my brain all week.

[ashishjuneja]

OMG... exactly what I was looking for.

Thanks a ton !!

[BernatAgulloRosello]

Just discovered this channel and it does bring a lot of value. Good rhythm good content, congrats!

[codewalters]

This video helped me . Thank you so much.

[michaeltadesse]

Thanks for the helpful video, also could you help me with the question, get most recent files FROM FOLDER in Power BI | What to do when new columns don't show?