Refresh breaks due to COLUMN NAME CHANGES? 3 ways to fix changing column headers in Power BI!

A simple Power BI column name change in the data source can break a power query refresh. It can be really frustrating that just by renaming column names, power bi refresh breaks... In this video I show you 3 different ways to fix changing column headers in Power BI.

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

---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
0:00 Intro
0:20 Refresh breaks on column name change
1:12 Option 1: Do not promote headers and rename all
2:33 Option 2: Use Table.ColumnNames
9:35 Option 3: When you do not know the column number
15:59 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

[terihandrick]

I want to thank you for all the YT videos that you have created for PBI. You have helped me through so many hurdles. Thank you for giving your time and talent.

[rantaleksi]

What I love most about your videos is that I basically learned like 5+ new things about M in just 16 minutes, and you explained them so well that I'm pretty sure I could just apply them anywhere after this.

[SolidSnake]

Wow. It's brilliant and so simple when you explain it. Thank you!

[alfreduvnick]

thank you for the idea, I did upgrade it so you create a column name list, keep it as a table, do all the edit query stuff you need, and at the end rename the columns back according to that table. this work amazingly with survey visualizations where you can change the words in question slightly and still keep all the visuals in the reports.

[Uno]

Definitely coming to your channel for all my PowerBi questions in the near future. I'm creating a dashboard to hopefully take on my companies Supply chain diagnostics, and this set of data was CRUCIAL!

[KB-wbym]

Thanks a million for such a great video and your time & effort mate, your teaching skills are just amazing..👌

[deepakgupta]

Thank you so much for this amazing video brother, this has solved one of my project report with client. thank u thank uuu...

[Sisi-vpxs]

Very useful. This is exactly what I'm looking for!

[duongtrinh]

Thank you so much. It works to me. This problem made me headache everytime related dept change their data raw's format

[jcoetz]

Thank you for the solution! Great video.

[rhys]

Great video, common problem and good solutions.

[eddiem]

Many thanks!! Solution #2 was just was I was needing.

[jerrymigliaccio]

Excellent content, examples and presentation, very useful video. Thank you!

[punit]

Very Much sought for thing by me...thanks for posting...

[jobinthomas]

Thank you boss! Appreciate this video very much!

[jaymehta]

Super amazing! Thanks for sharing this.

[decentmendreams]

Thank you so much. The topics are very relevant and your explanations are surgically precise .You do an amazing job of editing your videos. .
The only input I have is try to keep the split screen all the time .

[matthewbrierley]

THANK YOU SO MUCH!!! You are a true hero. This is brilliant.

[anirudsaichenna]

Great video, thank you for explaining it so well, outside this context I have a query, I have ".log" file with comma seperated data and without any column headers which I need to use as dataset to Power BI, and column count may change from time to time. Any suggestoin how to handle this situation. Apprecite your inputs here

[gabrielcoppolo]

Thank you so much! Does it work with fill values anytime a column name changes?