Forum Discussion
Number Error help please
I tried your suggestion. On two different columns they won't load the filter because they error out with "We couldn't convert to number."
do you know a way to search for that value in an entire table in edit query
Super UserAnonymous , check for data type value.type in power query. Create a new column and check and filter the one with different data type
I am not sure I follow: do you mean create a new column for each current column, but change the data type to any in the newly created column?
- amitchandak
Anonymous , in edit query mode create a new column that will show to data type of each row, see that can help to find the datatype issue
I have done this. All columns show data type Any. I don't see any difference in rows. Even with all columns as data type "Any" the query won't load, receiving the same error "cannot conver to number."