[DataFormat.Error] We couldn't convert to Number. Detalle: NA

[Syndicate_Admin]

Good night

I'm trying to find out why I'm getting an error loading a table that I created from 3 tables.

Specifically, the error occurs in the "price" column. The column in question has several null values that come from the 2017 and 2018 tables, but, as far as the 2019 table is concerned, it does not have any errors, nor alphabetical values, but if I apply a filter to the 2019 and 2017-2019 tables, I finally get the message "[DataFormat.Error] We couldn't convert to Number".

If I go to the "Query Errors" folder and go to the "price" column I see that all the records are "error" and when I click on one of them I get this message

The truth is that I don't know how to fix this error. If anyone can help me, I would appreciate it.

Thanks a lot

[Syndicate_Admin]

First thank you so much for responding so quickly, Jayleny

I have done what you have told me, but I still get the mistake. I then went to "Query Errors- Errors in sales 2017-2019" and the "price" column appears with all the failed records. I clicked on one of them and I keep getting the message "DataFormat.Error: We couldn't convert to Number.Details:NA"

Thank you very much for your attention.

[Anonymous]

Hi @Syndicate_Admin 

Null values can sometimes cause issues during data type conversion. Consider replacing null values with a default number (e.g., 0) that makes sense for your dataset. You can use the Power Query Editor to replace null values. 

Best Regards,

Jayleny

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

[Syndicate_Admin]

Buenas noches, Re: Copy Table from the Table View is not working

I have done the whole process again, from downloading the tables again from the files provided by the course I am taking, loading them in the power bi, replacing the NA and null records with 0, and then joining the tables into a single one, called "sales 2017-2018". I have applied the modifications and I got an error again, but in this case, the message I got is the following: Expression.Error: We cannot convert the value 6.5 to type Text. Details:Value=6,5Type=[Type]

If I position myself in another record I get the same message but with a different number

I don't know what I'm doing wrong.

Thank you very much for your attention and help.