ADF Dataflow Excel error

Santhi Dhanuskodi 66

Hi,

I am trying to read an excel file in dataflow using source activity. In import projection and data preview itself, I get error 'Empty string'.

When I open the excel file and expand some of the columns and reupload and run the dataflow, i dont get this 'empty string' error.
how to fix this automatically?

why this issue is occuring?

Please help me on this

Suba Balaji 11,186 Reputation points

2022-09-20T14:14:42.613+00:00

Hi @ShanthiDhanushkodi-2635,

Could you please post the full error details with some screenshot if possible?

Thanks
Santhi Dhanuskodi 66 Reputation points

2022-09-20T15:36:25.687+00:00

hi,
Below is the error screenshot on 'data preview'. I f I open the excel file manually and expand the columns and reupload, then I dont get this error.
Suba Balaji 11,186 Reputation points

2022-09-20T15:58:32.867+00:00

Looks like the error is on the second source?

Did you try to close the data flow and open again? May be it is an intermittent issue?

Are there any formulas present in the excel? or it is plain data?
Santhi Dhanuskodi 66 Reputation points

2022-09-20T16:59:22.007+00:00

Both the sources are pointing to same excel file.
And i wonder the error is gone just by expanding columns in excel.

And one more thing i want to ask why it shows error in other source when i click this source data preview.
Suba Balaji 11,186 Reputation points

2022-09-21T06:53:39.363+00:00

Hi @Santhidhanushkodi-2635,

I suspect if there is something to do with the cache sink, and it is the reason why it shows error on that source is due the fact that sink order is 1 in that flow.

can you try to have a different sink like, blob or data lake?

And, are you able to see data in the data preview of source data set? Can you see the schema there in the data set? Is there any column bringing some junk data? Sorry for too many questions, i tried to replicate by collapsing the XL and uploading to ADLS, data preview works just fine in data flow source.

can you upload the file if possible with some dummy data, to try the same from our end? May be it is one odd case with your file

Please let us know
Santhi Dhanuskodi 66 Reputation points

2022-09-21T13:12:59.53+00:00

Hi,

I am not able to uplaod xlsx file here. It doesnt allow xlsx file.

It is definetely not cache issue. Because same file is working after I expand the columns in the same pipeline.
Data preview only shows this error. I cannt import the schema also, the same error appears.
Suba Balaji 11,186 Reputation points

2022-09-21T13:53:44.563+00:00

Hi @santhidhanushkodi-2635

can you please try to create another data flow with excel (before expanding columns) as source and csv as sink in ADLS or Blob?
ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee

2022-09-23T09:38:56.99+00:00

Hi @Santhi Dhanuskodi ,

Unfortunately, we are not able to repro this issue. Could you please share your dataset settings once?
ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee

2022-09-27T15:55:55.287+00:00

Hi @Santhi Dhanuskodi , Just checking if you get chance to share requested details to help better? Thank you.