I'm trying to load an Excel file from Azure blob storage that has 10 columns with column headers. 2 of the columns are empty. In Basic Mode, it will not recognize any columns for Data Selection. In Advanced Mode it gives an error:
Parameter Validation Failure:
SQL Query - For input string: "0
"
Hi @stacey.manske could you explain it little clear it would make me to give solution to it.
After further investigation, I don't think it is the null columns. It's a file from a customer website. I was going to attach a sample but if I save it without doing anything to it and re-upload it to blob storage, it works, so the issue probably couldn't be replicated with a sample. Not sure what I can do to figure out what's wrong with the original file. I may need to add a couple of steps to the process that puts it into blob storage.
@stacey.manske Oh, that good If I found any solution to it I will get back to you.