#35. Azure Data Factory - Fix Mapping Column issue in Mapping Data Flow
In the pipeline, if we have a mapping data flow pointing to an excel file, it will have a set of columns defined as part of schema. If we change that file or create a new source, sometimes, you will end up seeing the total columns brought by the excel source to be 0. If it is the case, you will not be able to use the source in the data flow. This video explains a simple trick to refresh the schema and make the data flow work for you, Please watch it and let me know your comments.