Forum Discussion

sagdec1212's avatar
sagdec1212
Frequent Visitor
2 years ago

Data format error when using dataflow to import all files from a sharepoint

Hi all, I got an error "DataFormat.Error: We couldn't convert to Number" when I tried to use dataflow to extract all Excel files from a Sharepoint folder. The query I copied exactly the same from Pow...
Dataflow
Need Help
SaiTejaTalasila's avatar
SaiTejaTalasila
Super User
2 years ago

Hi sagdec1212 ,

 

As per my knowledge the helper queries generated while combining the files causing that issue.Import those files again on dataflow after combining the files you can edit the power query by copy paste the next transformation steps from your desktop file power query to dataflow.

 

 

 

Thanks,

Sai Teja 

  • sagdec1212's avatar
    sagdec1212
    Frequent Visitor
    2 years ago

    Hi Sai, sorry but I am a bit confused. Could you please explain more in detail? What should I do with the helper query (parameter/funcion)? Thank you so much!