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
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi sagdec1212 

 

You may need to modify the Power Query used in the dataflow to explicitly convert text to numbers. You can use the function to convert text values to numbers. Here's a simple example:

= Table.TransformColumns(YourTableName, {{"YourColumnName", each Number.FromText(_), type number}})

 

 

 

 

 

Best Regards,

Jayleny

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.