Forum Discussion

freidus's avatar
freidus
Regular Visitor
8 years ago

DataFormat.Error: We couldn't convert to Number.

Hi   I am a real beginner in Power BI and I would greatly appreciate some help.   I am importing a large number of rows from 8 csv files (about 3m rows).   A large number of these rows is comin...
freidus's avatar
freidus
Regular Visitor
8 years ago

Sorry for the delayed response, but I have been struggling to reproduce the error in a data excerpt. 

 

It may be though, that once I upgraded to the November version, the problem has become sorted. I still need to load the full dataset to see if this is the case. 

 

I will revert with feedback.

 

Thank you all again for your help.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

freidus，

How is the issue going?

Regards,
Lydia

  • freidus's avatar
    freidus
    Regular Visitor
    8 years ago

    Thanks for checking up on this.

     

    I actually am at a total loss and I've tried to work around the issue.

     

    I managed to clean up my data in Python which seems to skirt the issues I was facing.

     

    However, even with this clean data, it seems that when I change the data format using the query editor, errors are shown. However, when I do it in the data view using the modeling tab, it works.

     

    Seems like I'm just going to have to use the workarounds...