Refreshing a Data Source with Missing Column

[pasieng]

Hello, I'm trying to replace one of my data sources in my Power BI dashboard.  My original data source has columns A, B, C, and I would like to replace it with a data source that only contains columns A and C (new version of the report no longer contains Column B). Is there a way to replace it without having an error because column B is missing. Thanks!

[lbendlin]

Learn about the difference between Table.RemoveColumns and Table.SelectColumns  (hint - use the latter)

There are also Power Query techniques to handle "MissingColumn"  - but these are more advanced.