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
🎵 Song credit to Limujii, Sweet Talks, if you would like to check it out: • Sweet Talks – Limujii (No Copyright M...
✅ Please see links to videos mentioned in this video:
🎦 Power Query Age Analysis - Create an Excel Age Analysis Report Using Power Query: • Power Query Age Analysis - Create an ...
🎦 Power Query Error Handling - How to Deal with Power Query Errors Part 1: • Power Query Error Handling - How to D...
✅ If you would like to connect on LinkedIn:
🤝 www.linkedin.com/in/missmicrosoft
✅ 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:
☕https://www.buymeacoffee.com/missmicr...
✅ For more videos please subscribe:
🔔 / @missmicrosoft
✅ For more Power Query videos please use the links below:
🎦 Power Query in Excel Beginners Tutorial: Combine Multiple Excel Sheets, Automate & Transform Data: • Excel's Power Query: The Ultimate Beg...
🎦 Combine Data from Multiple Sheets into One Sheet in Excel: • Easiest Way to Combine Data from Mult...