Error loading Excel file from Blob

David 21 Reputation points
2021-07-13T16:45:35.953+00:00

We get Excel files uploaded to our Blob storage from another group. We are trying to copy the contents to an Azure SQL table. The issue I am having is with the format of the Excel file. It is using row groupings and is causing errors when being read by the ADF dataset 'Object reference not set to an instance of an object'

If I manually remove the row groupings and resave the file, it reads fine in the copy activity in the pipeline. Is there a way in ADF to get rid of the row groupings or am I going to have to write a separate process to manually do this?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,751 questions
0 comments No comments
{count} votes

Accepted answer
  1. KranthiPakala-MSFT 46,427 Reputation points Microsoft Employee
    2021-07-14T03:59:41.29+00:00

    Hi @David ,

    Welcome to Microsoft Q&A forum and thanks for your query.

    Unfortunately this there is no direct way to achieve your requirement within ADF to remove the row grouping. You will have a do it either outside ADF before processing file to ADF pipeline or you could try to utilize ADF custom Activity or Azure Function activity and write your own code to remove the row grouping and then have the actual copy data activity to copy data to your desired sink.

    Hope this info helps. Do let us know if you have further query.

    ----------

    Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful