ADF "Index out of range" when reading XLSX with hidden columns

Question

@HarithaMaddi-MSFT @KranthiPakala-MSFT @PRADEEPCHEEKATLA-MSFT
Hello everyone,

I have a XLSX file generated by a system, and this file has 3 hidden columns on the start (columns A, B, and C). These columns aren't important and can be ignored if necessary.

So, I've created a connection to this file using a Self-Hosted Integration Runtime. But, when I try to preview the data, I'm receiving this error:
"The value of the property 'index' is invalid: 'Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index'.
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index"

If I change the sheet, showing back the columns, everything works fine, but it's not the ideal solution.

Other tests I've made:

• Input a Range, excluding these columns, same error
• Leave the schema as is and just delete de mapping for these columns on the copy task, same error.
• Tried to change the connection using the code, removing the hidden columns, same problem.

I appreciate any support.

Thank you.

Answer 1

Hello @Alexandre Von Mühlen ,

We just heard back from the PG team and they have confirmed that this scenario is not supported in the current implementation .
I would suggest you to add this idea at https://feedback.azure.com/forums/270578-data-factory
All of the feedback you share in these forums will be monitored and reviewed by the Microsoft engineering teams responsible for building Azure.

Once you have added the idea , please do share the url here , so that others can benefit from them and upvote the ask ,

Thanks
Himanshu