DataFormat.Error We coulnd´t convert to number

[Anonymous]

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

[AlB]

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 · Accepted solution]

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.