I solved this by using Copy Activity with the http connector and configuring the source dataset as Excel and sink dataset as parquet. Now I can read parquet into the Data Flow and process the files.
Thanks.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Anyone here to help me configure the Azure Synapse Copy Activity or any other type of activity to download excel files from a cloud storage such as Dropbox and save it as it is in ADLS? The only option I have seen and tried is to configure the Copy Activity using the http connector with the source as Binary and sink as Binary, but that doesn't make it available for processing in Data Flow. I want them saved as Excel just as they would be saved if manually uploaded. Data Flow doesn't have Binary as an option for source.The files are huge to download and upload manually so I can only use the http connector to download the files but I am stuck on the destination format since there is no option for saving it as Excel. The files are not .csv but .xlsx and .xls so I cannot go for Delimited Text.
Anyone knows how this works?
Thanks,
Chaiwa.
I solved this by using Copy Activity with the http connector and configuring the source dataset as Excel and sink dataset as parquet. Now I can read parquet into the Data Flow and process the files.
Thanks.
Hi @Chaiwa ,
Thankyou for using Microsoft Q&A platform and thanks for posting your question here.
zipdeflate
and compression level as Optimal
. This will unzip the file on the fly . I am still checking on the error you are getting due to limitation of file size. However, please feel free to try the above approach and let us know if it helps.
Check the below screenshot for sink dataset of copy activity:
Hope this will help. Please let us know if any further queries.
------------------------------