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

Alexandre Von Mühlen 1 Reputation point
2020-10-20T14:35:23.897+00:00

@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.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,568 questions
{count} votes

1 answer

Sort by: Most helpful
  1. HimanshuSinha-msft 19,471 Reputation points Microsoft Employee
    2020-10-28T18:47:47.067+00:00

    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

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.