Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DataFormat.Error We coulnd´t convert to number

Can somebody explain me why I get the DataFormat.Error? My colum "Impact description" allows Textand numbers. I have this same error in many columns

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    I solved it. I did do a query out of a folder. And I did the changes of the data type in the merged file (1) and once I did it in (2) it worked.

     

2 Replies

  • AlB's avatar
    AlB
    Community Champion
    5 years ago

    Hi Anonymous 

    Can you share the pbix ?

    Or a sample of the data that is causing the errors plus the M code you are using?

     

    		 Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I solved it. I did do a query out of a folder. And I did the changes of the data type in the merged file (1) and once I did it in (2) it worked.