Showing results for 
Search instead for 
Did you mean: 
New Member

Couldn't conver to number error

Hello everybody,

I've been getting a we couldn't convert to error error for a few days now.
Because the data is too big, I can't check it from excel.
I tried remove empty and remove error but it didn't work.
Also, as you can see in the picture, the "Total" column looks completely clean.
I'll be happy if you can help me.


Super User
Super User

Hi @recepphaneci ,


It is possible that the error is not showing up because your dataset is only showing the first 1000 rows.

try to double click the message on lower left and select entire dataset.



Please let me know if this helps.





I tried that, but my data is too large i guess. 


Here the ss.


Responsive Resident
Responsive Resident

@recepphaneci ,
seems like this might be in other queries ( Vendor/ DimPersonnel / Kapsam..).
If you close and apply, a query with the row number and error table along with it's columns show up.


Once the row/column is identified, left-click on the error and it should show what charecters are causing this which could then be replaced.


Appreciate a thumbs up if this is helpful.

Hey thanks for reply first of all, 


I can't get a error table. It is the one of my problem


How can i get it? 


I try to close and apply and it doesn't showed up. 1.jpg2.jpg

This is the kind of message to look for:
While loading after close an apply ( in your example, find the previous table which is causing the error, should look like this) 


if you click on View Errors


Row number and errors in table query will show





clicking on the error the values causing it will show



maybe this helps: How to deal with errors in Power Query (2 ways) - YouTube


Yes, I understand that just it doesn't showed up show the error box for me. 


Helpful resources


2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors