Unrecognized extension in ADLS

Madhan 1 Reputation point
2022-01-24T06:44:04.627+00:00

Hi, I'm downloading files from HTTP using Binary dataset in Copy Activity and Saving the file in ADLS using Binary Dataset. I'm using Binary dataset because the HTTP url(source) will have different file types dynamically. I'm getting the filename is url response and also allocating it to sink dataset as filename along with extension while storing files in ADLS. But while trying to open the file, ADLS showing

The file 'abcd.xls' may not render correctly as it contains an unrecognized extension.

However if i download the file locally and open, the file is opening properly.

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,358 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,422 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,650 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AnnuKumari-MSFT 31,151 Reputation points Microsoft Employee
    2022-01-24T08:40:07.847+00:00

    Hi @Madhan ,
    Thankyou for using Microsoft Q&A platform and posting your query.

    The online view/edit is not supported for Excel file. Editing an unsupported file format in online editor will cause the file been corrupted.

    You can view/edit the file after downloading in your local system.

    Hope this will help. Please let us know if any further queries.

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you.
      Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators