Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
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.