Refresh Breaks - Avoid the Column of the Table Wasn't Found Error & Dynamically Change Column Names

Refresh Breaks - Avoid the Column of the Table Wasn't Found Error & Dynamically Change Column Names - In this video we’re going to take a look at how to prevent the table of the column wasn’t found error that causes your refresh to break when you reorder columns, when columns are missing and when column names change and how to make these changes dynamic.

00:00 The Issues that Cause Your Refresh to Break
00:21 Reordered Columns Error
02:41 How to Dynamically Add Missing Column Names
05:46 How to Dynamically Change Column Names

✅ Please see links to videos mentioned in this video:

✅ If you would like to connect on LinkedIn:

✅ If you would like to buy me a coffee, so I can get my caffeine in to keep creating as many videos as possible for you :). It's really quick and easy, please use this link:

✅ For more videos please subscribe:

✅ For more Power Query videos please use the links below:

[flaviobertasi]

Great video, thank you very much. May I make a small suggestion: Do without the music if you can. It distracts from your excellent explanations.

[Mohamed-xtfp]

Thanks miss microsoft!, ps:the music is distracting.

[alexrosen]

By far one of the most useful tutorials relating to Power Query

[pegwinn]

Most excellent. Thank you for doing this.

[norpriest]

Thank you.
Have you ever come across Expression Error: We cannot convert value 0 to type Text?

It occurred when I tried to Close and Load after finished merging tables.

[daveindallas]

Thank you for good content. The music is extremely distracting. Please let it be muted or just remove it.

[navedsaiyed]

Hola...This is imperative for me as i was having trouble due to changing column names & now i have solution to it.

[thebhaskarjoshi]

Where else can we use MissingField. Ignore or Null?

[Fearlessness]

The best video about this content that I found here on YT. Thank you a lot <3

[MrDhunpagla]

🤗🤗.... Awesome ...Thanks ....For sharing with us

[thebhaskarjoshi]

Very helpful video! Thank you!
Please also make a video on {"try & catch ", "try & otherwise"}