question

David-6243 avatar image
0 Votes"
David-6243 asked KranthiPakala-MSFT answered

Error loading Excel file from Blob

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

KranthiPakala-MSFT avatar image
1 Vote"
KranthiPakala-MSFT answered

Hi @David-6243,

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.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.