Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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

I have a .pbix file that has been running great for two weeks, refreshing as expeted.  The source of these dashboards are two .csv files.   All of a suddent I am receiving the message below:   ...
Need Help
Show and Tell
  • SteveCampbell's avatar
    SteveCampbell
    8 years ago

    Did you change the columns in the editor? Make sure you go back and replace the steps - otherwise it will try to convert to number, then back so will still errror out.

     

    In the applied steps in the Query Editor, make sure you go back to all the changed type steps and click on them. Then, you can do your tranaformation on this step. Make sure you click replace current.

     

     

    Power BI usually looks at a subset of rows to determine the format. It is likely you have a column with many numbers and a small amount of text somwhere.

SteveCampbell's avatar
SteveCampbell
Memorable Member
8 years ago

Did you change the columns in the editor? Make sure you go back and replace the steps - otherwise it will try to convert to number, then back so will still errror out.

 

In the applied steps in the Query Editor, make sure you go back to all the changed type steps and click on them. Then, you can do your tranaformation on this step. Make sure you click replace current.

 

 

Power BI usually looks at a subset of rows to determine the format. It is likely you have a column with many numbers and a small amount of text somwhere.

melisseker's avatar
melisseker
Regular Visitor
3 years ago

hi,

 

I am uploading the data from a csv file but power bi gives the error as shown below for some values:

 

 

Could you please help me fix the issue?

 

Thanks!