Data Format Error Details: _______

[BeeTee]

I have referenced a table in power query, called Responses.  The new table is called Questions and is meant to be one column containing a distinct list. Everything works fine until the remove duplicates step when I get a single row with an error. The error says DataFormat.Error: We couldn't convert to Number. The details are blank. The column is formatted as text. I have tried removing errors, and replacing errors but nothing is working. I can't figure out where the error is coming from.

Before removing duplicatesAfter removing duplicatesError

[v-pagayam-msft]

Hi @BeeTee ,

I just wanted to kindly follow up to see if you had a chance to review the previous response provided by us. I hope it was helpful. If yes, please Accept the answer so that it will be helpful to others to find it quickly.

Thank you.

[v-pagayam-msft]

Hi @BeeTee ,
I wanted to check in on your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply that helped you or sharing your solution. It would be greatly appreciated by others in the community who may have the same question.

Thank you.

[v-pagayam-msft]

Hi @BeeTee ,
I wanted to check in on your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply that helped you or sharing your solution. It would be greatly appreciated by others in the community who may have the same question.

Thank you.

[v-pagayam-msft · Accepted solution]

Hi @BeeTee ,
Thank you for reaching out to us!
It looks like Power Query might be misunderstanding some of the values in the column, trying to treat them as numbers even though it set the column to Text.Here are the steps which might help you:

• Click on the "Question" column and change its data type to Text again by going to the Transform tab and selecting Data Type > Text.

• Be aware that some values might have invisible characters, such as spaces or special symbols, which could be causing the conversion issue, use Power Query 'Clean' or 'Trim' function to preprocess the data if needed.

• Also, check in the Applied Steps pane on the right side, see if Power Query has added a "Changed Type" step automatically. If it has, you may delete this step and manually set the column type to Text instead.

Hope this helps,If so,consider accepting it as solution.

[lbendlin]

Does Row 91 exist in that step?