Hi All,
My source is an sftp excel file and destination is ADLS. When i create the source data set and click on sheet name to load i am getting the below error. Please advice.
Failed to import source schema. The excel file 'EncounterData.xlsx' size is big and will lead interactive operation timeout, please use sample file to have import schema, preview data and get worksheet list. . Activity ID: 46cc7126-be0b-4468-912d-eaeedd701901
As the message says to use a sample file, it is not possible as the file is not local nor on the network it is an sftp site.
Please need help.
Thanks
