'Read excel files with different schema is not supported now in Dataflow (ADF)?

I am having a lot of excel files in the data lake. I am trying to read in dataflow and getting below error

"Read excel files with different schema is not supported now."

All my excel files are in the same format having the same column names. However, it's still coming above error.

enter image description here

Nor sure what is the issue? Can anyone advise how to solve this?

azureazure-data-factoryazure-data-flow


Solution 1:[1]

I see this is a known issue and is documented in the official MS docs. Can please try their recommendations.

enter image description here

Solution 2:[2]

You most likely intend to pull from multiple sheets in a folder. All the sheets do not have the same schema and that's the issue I had.

You'd need to identify the file with a different schema or take out the file path where it says wildcard path Remove content from the wildcard path

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 KarthikBhyresh-MT
Solution 2 ToyinO

Related Questions